Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle that can convert regional date to a GMT date?

Re: Oracle that can convert regional date to a GMT date?

From: Michel Cadot <micadot2removethat_at_free.fr>
Date: Wed, 10 Sep 2003 22:03:13 +0200
Message-ID: <3f5f82c5$0$28879$626a54ce@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
Received on Wed Sep 10 2003 - 15:03:13 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US