View Single Post

   
  #1 (permalink)  
Old 04-08-2008, 10:05 AM
=?iso-8859-1?B?TWVscXXtYWRlcw==?=
 
Posts: n/a
Default Obtain server timestamp

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!

Reply With Quote