Re: Obtain server timestamp

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Sat, 25 Mar 2006 20:21:11 +0100
Message-ID: <44259827$0$21542$626a54ce@news.free.fr>

"Melquíades" <srsuarez_at_gmail.com> a écrit dans le message de 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!

|

You can easely do it if you know the base of your number. What does 0 mean?

Regards
Michel Cadot Received on Sat Mar 25 2006 - 13:21:11 CST