OraFAQ Forum: Server Administration » more précise : convert from Unix date to DD/MM/YY

Home » RDBMS Server » Server Administration » more précise : convert from Unix date to DD/MM/YY

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

more précise : convert from Unix date to DD/MM/YY [message #370839]

Tue, 15 February 2000 05:16

Emmanuel
Messages: 6
Registered: February 2000

Junior Member

In database i have table with open_date = 950277645 (for example): it's not the 95-02-etc...
-
it's the numbers of seconds since ??? like unix date.
-
the software using oracle translate this number to a date format.
I try to make a select on open_date : OK
But i would like to have a date format like : "dd/mm/yy" ! please ?.......

Anyone know ?

Emmanuel from France-Paris

Report message to a moderator

Re: more précise : convert from Unix date to DD/MM/YY [message #370842 is a reply to message #370839]

Tue, 15 February 2000 06:51

Paul
Messages: 164
Registered: April 1999

Senior Member

Emmanuel,
You are probably right, can you create (or get someone to create) a record with an open date of the current date. If so, you can substitute that number into this SQL:
select sysdate - (959277645 / 84600) DAYS
from dual;
and come up with the date you are offsetting from.
You can then use
select to_date(returned_date) + (open_date / 84600) days
from your_table;
to get the open_date.
Hope this helps,
Paul

Report message to a moderator

Previous Topic:	Self Join- Corelated subquery
Next Topic:	PL/SQL

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun May 04 05:09:30 CDT 2025