RE: sql date processing

["Phil" <sublime78ska@xxxxxxxxx>]

Try replacing '0001-01-01' with '1970-01-01'

I don't know what the earliest permissible date is.  Hopefully earlier than
1970.  But by doing this test you'll see that sql doesn't accept
'0001-01-01' as a valid date.

Phil

-----Original Message-----
From: owner-rpg400-l@midrange.com [mailto:owner-rpg400-l@midrange.com]On
Behalf Of Smith, Mike
Sent: Monday, April 30, 2001 8:13 AM
To: RPG400-L@midrange.com
Subject: sql date processing


I've have a physical file defined with 2 date fields stored as 'L' data type
A Start date and and End Date.   When i read the file  with a Fetch
statement and the End Date is filled only with '0001-01-01', I get a -183
error code.

The data doesn't seem to get loaded into my data structure, so i cannot
manipulate the date, so what do i do?

How do i approach the coding to handle something like this?
any suggestions?

thanks

Mike

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


_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.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
+---