Re: Date Convertion

["David Wright" <dwright2@xxxxxxxxxxxxxxx>]

This should work....

           Select  * From FILE1, FILE2
           Where  FILE1.P4CPS8 > (FILE2.CUTDT+19000000)

Example:
        1001114   (Nov 14, 2000)
 +   19000000
==========
      20001114

Dave


----- Original Message -----
From: "Jonathan Oblea" <JOBLE@amkor.com>
To: <RPG400-L@midrange.com>
Sent: Tuesday, November 14, 2000 9:27 PM
Subject: Date Convertion


>
>
>
>
> Hello All,
>
> Does anyone knows how to convert a YYYYMMDD into CYYMMDD format inside an
SQL
>       statement ?
>
> I will be needing this for comparison purposes in SQL.
>
>
>
> Sample SQL:
>
>           Select  * From FILE1, FILE2
>           Where  FILE1.P4CPS8 > FILE2.CUTDT
>
> Note: P4CPS8's length is 8 char with YYYYMMDD
>             CUTDT's length is 7 numeric with CYYMMD
>
>
>
> Thank you in advance,
>
> Jonathan
>
>
> +---
> | 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
> +---
>

+---
| 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
+---