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

From: Michel Cadot <micadot2removethat_at_free.fr>
Date: Fri, 12 Sep 2003 07:47:34 +0200
Message-ID: <3f615d4e$0$20161$626a54ce@news.free.fr>

"Holly" <hollyyu2003_at_yahoo.com> a écrit dans le message de news:c32c40c2.0309111328.efed33a_at_posting.google.com...
> "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

sys_extract_utc does not exist in 8i.
You can use new_time.
For instance, if your time is in Eastern Standard Time you can convert to GMT with: select new_time(start_date,'EST','GMT') from invoice;

Regards
Michel Cadot Received on Fri Sep 12 2003 - 00:47:34 CDT