Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Obtain server timestamp

Obtain server timestamp

From: Melquíades <srsuarez_at_gmail.com>
Date: 25 Mar 2006 11:09:31 -0800
Message-ID: <1143313771.311129.14090@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!
Received on Sat Mar 25 2006 - 13:09:31 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US