[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
Re: Date formatting problem
Have you included the
#Include 'setupdb.sqc'
statement in your begin setup section?
The other thing is that you might need to use an edit mask. For
Oracle TO_CHAR (<fieldname>,'DD-MON-YYYY') &<variable>
placed into the select statement.
> Hello all,
>
> I am sorry, if this has been discussed 'n' number of times before.
>
> I am trying to convert date from source file in the format
> '06/21/99' to '21-JUN-1999'. Could u pl let me know the most efficient way
> of achieving this? I am currently using the 'Format_datetime' procedure
> thru the datetime.sqc, but not achieving the correct results.
>
> Thanks
> DJ
>
>
> _______________________________________________________________
> Get Free Email and Do More On The Web. Visit http://www.msn.com
Pete Lewandowski
Analyst/Programmer
818-677-7539