OraFAQ Forum: Unix » Unix Timestamps

Home » Infrastructure » Unix » Unix Timestamps

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Unix Timestamps [message #126045]

Thu, 30 June 2005 12:16

piepoen
Messages: 3
Registered: June 2005

Junior Member

Hi,

I try to programm a search function with PHP. I created a view that includes all the fields necessary for the search.
As I saved my time as a unix timestamp I'm looking for a way to convert it into a readable form.

How can I convert a unix timestamp in Oracle?

Thanks,
piepoen

Report message to a moderator

Re: Unix Timestamps [message #126047 is a reply to message #126045]

Thu, 30 June 2005 12:20

piepoen
Messages: 3
Registered: June 2005

Junior Member

Sorry for the mess, but I had some problems loading the site. Embarassed

Maybe somebody can delete the double posts. Thanks!

Sorry!

Report message to a moderator

Re: Unix Timestamps [message #126053 is a reply to message #126047]

Thu, 30 June 2005 12:43

andrew again
Messages: 2577
Registered: March 2000

Senior Member

http://www.quest-pipelines.com/pipelines/plsql/archives/Unix_To_Oracle_Date.sf

Report message to a moderator

Re: Unix Timestamps [message #126062 is a reply to message #126053]

Thu, 30 June 2005 14:02

piepoen
Messages: 3
Registered: June 2005

Junior Member

It's working!
Thanks!

Report message to a moderator

Previous Topic:	Pass Values from SQL to UNIX
Next Topic:	Component oracle.swd.jre 1.1.8.10.0. not found while installing oracle 9i Application server in Win2

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 13:46:58 CDT 2024