Home » RDBMS Server » Server Administration » more précise : convert from Unix date to DD/MM/YY
more précise : convert from Unix date to DD/MM/YY [message #370839] Tue, 15 February 2000 05:16 Go to next message
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
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 Go to previous message
Messages: 164
Registered: April 1999
Senior Member
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,
Previous Topic: Self Join- Corelated subquery
Next Topic: PL/SQL
Goto Forum:

Current Time: Tue Oct 20 09:57:42 CDT 2020