Re: SQL and Date Data Types

["Jay Peasley" <jpeasley@xxxxxxxxxx>]

John of Canada,

Isn't the *ISO format 'ccyy-mm-dd'? The files I query all the time have the
date format of *ISO. If I use '20001026' or '2000/10/26' the query fails. It
works fine if I define it the literal as '2000-10-26'. Yes, my job had a
format of MDY and a seperator of '/', so a literal qualified as '10/26/2000'
will work, but I do feel the correct seperator is needed.

Jay
US eh

----- Original Message -----
From: "John Taylor" <john.taylor@telusplanet.net>
To: <MIDRANGE-L@midrange.com>
Sent: Thursday, August 17, 2000 5:42 PM
Subject: Re: SQL and Date Data Types


> Jay,
>
> It's not necessary to match the character literal to the format of the
date
> field. It's only necessary to use one of the formats that SQL can easily
> identify (*USA,*ISO,*EUR,*JIS), or to format it according to whatever
> format/separator is in effect for the job (or program if it's embedded
SQL).
>
> Regards,
>
> John Taylor
> Canada
>
> ----- Original Message -----
> From: "Jay Peasley" <jpeasley@arbsol.com>
> To: <MIDRANGE-L@midrange.com>
> Sent: Thursday, August 17, 2000 12:57
> Subject: Re: SQL and Date Data Types
>
>
> > If the date is in an ISO format it would be '2000-10-26' date format.
> >
> > select * from orderpf where ohdate = '2000-10-26'
> >
> > Jay
> >
> > ----- Original Message -----
> > From: "Stone, Brad V (TC)" <bvstone@taylorcorp.com>
> > To: <MIDRANGE-L@midrange.com>
> > Sent: Thursday, August 17, 2000 12:06 PM
> > Subject: SQL and Date Data Types
> >
> >
> > > 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"
> > >
> > > Thanks!
> > >
> > > Brad
> > > +---
> > > | 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
> > > +---
> > >
> >
> > +---
> > | 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
> > +---
> >
>
> +---
> | 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
> +---
>

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