View Single Post

   
  #7 (permalink)  
Old 04-08-2008, 10:05 AM
DA Morgan
 
Posts: n/a
Default Re: Obtain server timestamp

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@x.washington.edu
(replace x with u to respond)
Reply With Quote