Re: Need help Datefield Retrieval like this mmddyyyy

[Srilatha Rao <srilatha@HOTMAIL.COM>]

Hi,

You can do that within begin-select

begin-select
..
..
..
TO_CHAR(startdate,'MMDDYYYY') &temp_date ! Storing in bind variable
..
...
from table_name
where conditions
end-select



>Date:         Wed, 23 Sep 1998 12:06:38 -0400
>Reply-To: SQR-USERS@USA.NET
>From: Dominick Logiudice <dlogiudice@PINE.VPCC.SUNYSB.EDU>
>Subject:      Need help Datefield Retrieval like this mmddyyyy
>To: Multiple recipients of list SQR-USERS <SQR-USERS@list.iex.net>
>
>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
>


______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com