Re: Convert Epoch (in milliseconds) to Date Format

tereglow schrieb:
> Hello all,
>
> Bear with me here, I'm a Unix Admin., not a DBA!
>
> I have a query that returns a field with its corresponding timestamp
> of when it was created. The timestamp is returned in epoch format,
> measured in milliseconds. Is there a way to convert this into a
> normal date within Oracle?
>
> For example:
>
> SELECT server, createtime
> FROM servers;
>
> This gives me:
>
> server1 | 1171391881904
>
> I need the epoch in milliseconds to show a human readable date. I.e.
> something like YYYY-MM-DD hh:mm:ss or the like.
>
> I appreciate any help,
> Tom
>

SELECT server, createtime,DATE '1970-01-01' + createtime/(1000*60*60*24) FROM servers

?

Best regards

Maxim Received on Thu Jun 07 2007 - 09:37:47 CDT