Re: Obtain server timestamp

From: Jim Kennedy <jim>
Date: Sat, 25 Mar 2006 11:31:52 -0800
Message-ID: <R5SdnUrV8ua8B7jZRVn-rQ@comcast.com>

"Melquíades" <srsuarez_at_gmail.com> wrote in message news:1143313771.311129.14090_at_u72g2000cwu.googlegroups.com...
> Hi!
> I need to obtain the server current timestamp. I know that some selects
> like "SELECT CURRENT_TIMESTAMP FROM dual;" gives the current
> timestamp, but with a non standard format (10-Sep-05 10.58.24.853421 PM
> -07:00) . I need a timestamp on numeric format type, like this
> "1139865932".
> How can I do it?
> Thanks!
>

Don't people even TRY reading documentation anymore? go to otn.oracle.com and click on documentation. Go to the SQL Reference guide and look at the table of contents. Look at format models and timestamps. You would be amazed at the wealth of information there. Jim Received on Sat Mar 25 2006 - 13:31:52 CST