RE: An SQL question...

["MCPARTLAND, Stan" <stanley.mcpartland@xxxxxxxxxx>]

Rich,

An answer to part of your question.  Use DATE and DIGITS to concatenate your
date components into a date field.  The separators indicate the format of
the date (e.g., "." for *ISO).  The example below includes a calculation for
the century which you won't need.

Regards,
Stan

SELECT field1, 
     field2,
     case 
       when day = 0
          then null
       when year < 79
          then date('20' || digits(year) || '-' ||
          digits(month) || '-' || digits(day)) 
       else
          date('19' || digits(year) || '-' || 
          digits(month) || '-' || digits(day)) 
      end as field3
  FROM file
  ...

-----Original Message-----
From: Rich Duzenbury [mailto:rduz@westernmidrange.com]
Sent: Friday, 09 March, 2001 11:25 AM
To: RPG400-L
Subject: An SQL question...


<snip>

But, the goal of todays exercise is to see if it's possible with SQL.  The 
big question is how to select the account with the highest create date, 
since the designers chose to store the date components in separate fields?

<snip>
+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---