| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Re: Converting UNIX time to GMT
Hi
On Wed, 21 Aug 2002 15:03:42 +0100, "Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote:
>I think what Marc was saying was that his data was stored as a number
>represetning the number of seconds since 1/1/1970. Something like this (from
>our helpdesk system)
I've run across this sort of thing before. Usually I just code up a simple C conversion program and then set it up as a PL/SQL callable external proc. The conversion is trivial to do at the UNIX level - number goes in and GMT date+time comes out as a string which can then be used in a to_date() .
Marc: Let me know if you need more info on this.
Cheers
Dale Edgar
Net 2000 Ltd.
Dale_at_DataBee.com
 |
 |