"Michel Cadot" <micadot2removethat_at_free.fr> wrote in message news:<3f615d4e$0$20161$626a54ce_at_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
It works both way, thank you very much Michel!
Holly
Received on Fri Sep 12 2003 - 13:09:42 CDT
