| 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
|
|
|
|
| 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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
