Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Dates in Oracle
How are you getting that?
select myfield from myTable where id=x ?
If you have a date field and you want it in a character format you can do
select to_char(myField,FORMAT_SPEC) from myTable...
e.g. FORMAT_SPEC='mm/dd/yyyy' then you would get 12/07/2001
or 'mm/dd/yyyy hh24:mi:ss' might get 12/07/2001 14:32:01
Jim
"TC3 Racer" <samsmith_at_parktechnology.co.uk> wrote in message
news:1caQ7.1531$Jm.79872_at_stones...
> I have a date/time stored in table as 1007718960, this relates to sometime
> in the 07Dec01. How do I convert the integer to a date/time
>
> Thanks
>
> GC
>
>
Received on Fri Dec 07 2001 - 16:34:29 CST