Holly wrote:
>"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
>
>
It does not work in Oracle because Oracle is not MySQL. Go to
http://tahiti.oracle.com and learn
the syntax for the product you are using.
--
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)
Received on Thu Sep 11 2003 - 16:57:21 CDT
