Re: SQL and Date Data Types

[Pete Hall <pbhall@xxxxxxxxxx>]

At 11:06 08/17/2000 , Brad Stone wrote:
>Anyone have any tips or tricks on selecting records with a Date Data Type
>field using SQL?
>
>select * from orderpf where ohdate = '10/26/2000'
>
>and ohdate is type "L"

Try using date('2000-10-26') in place of '10/26/2000'. You should be able 
to use date('10/26/2000') too, if your SQL date format is set to *USA, or 
even date('10/26/00') if you use *MDY. The date command will cast the 
literal to a date data type, and it's pretty good at figuring out how to 
coerce whatever you give it into a date. I always use *ISO format, but I 
just tried the *YMD and *USA syntax in ISQL, and all three worked without 
changing anything. I suspect that in a procedure the behavior may not be as 
forgiving, but I haven't tried it.


Pete Hall
pbhall@execpc.com
http://www.execpc.com/~pbhall/
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---