Re: Need help Datefield Retrieval like this mmddyyyy

[Julie Cochrane <Julia_Cochrane@IINT.COM>]

In your select statement in your sqr program, to_char it.

to_char(fieldname, 'MMDDYYYY')     &variablename

When you to_date it later to use it, if you do, be sure to check 2000 dates
to make sure they
don't get turned into 1900 dates.  Putting the to_date command (if you have
to insert &variablename
into a field in a database table later in your SQR program) inside a PL/SQL
paragraph works
correctly.  In my experience, just using to_date in a plain old
begin-insert or begin-update turns
2000 dates into 1900 dates.

(To to_date it, to_date(&variablename, 'MMDDYYYY') )

Julie




Dominick Logiudice <dlogiudice@pine.vpcc.sunysb.edu> on 09/23/98 12:06:38
PM

Please respond to SQR-USERS@USA.NET

To:   Multiple recipients of list SQR-USERS <SQR-USERS@list.iex.net>
cc:    (bcc: Julia Cochrane/Atlanta/Indus/US)
Subject:  Need help Datefield Retrieval like this mmddyyyy




Say I have a field called start date on a oracle db
I want to retrieve in like this mmddyyyy
How would I do this with sqr
Thanks