Convert Epoch (in milliseconds) to Date Format

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 Received on Thu Jun 07 2007 - 09:31:10 CDT