"Melquíades" <srsuarez@gmail.com> wrote in message
news:1143313771.311129.14090@u72g2000cwu.googlegro ups.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!
>

Don't people even TRY reading documentation anymore? go to otn.oracle.com
and click on documentation. Go to the SQL Reference guide and look at the
table of contents. Look at format models and timestamps.
You would be amazed at the wealth of information there.
Jim