"Michel Cadot" <micadot2removethat_at_free.fr> wrote in message news:<3f5f82c5$0$28879$626a54ce_at_news.free.fr>...
> "Holly" <hollyyu2003_at_yahoo.com> a écrit dans le message de
> news:c32c40c2.0309101123.78e22662_at_posting.google.com...
> > Is there a stardard oracle SQL function that convert reginal date to
> > GMT(Greenwich Mean Time)?
> > Thanks
>
> in 9i, sys_extract_utc to get the GMT time from a datetime with time zone.
>
> Hope this helps
> Michel Cadot
In my SQL, should i write "select sys_extract_utc(start_date) from invoice"
also, does this work for 8i?
Thanks
Received on Thu Sep 11 2003 - 16:28:18 CDT
