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 -> Re: Obtain server timestamp

Re: Obtain server timestamp

From: DA Morgan <damorgan_at_psoug.org>
Date: Mon, 27 Mar 2006 11:32:57 -0800
Message-ID: <1143487969.657348@yasure.drizzle.com>


Melquíades wrote:
> 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!

Write your own function.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Mon Mar 27 2006 - 13:32:57 CST

Original text of this message

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