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

Home -> Community -> Usenet -> c.d.o.tools -> Re: Getting GMT Time in Oracle?

Re: Getting GMT Time in Oracle?

From: whoever <fred_at_nowhere.net>
Date: Mon, 30 Oct 2000 15:47:47 -0600
Message-ID: <8tkqa0$v35$0@pita.alt.net>

Oops I mised you saying you can't use new_time. But, why can't you? Don't you know the current time zone of the machine(s) you're on? Also, I thought DST was taken care of automatically (could be wrong here, thoguh)

whoever wrote in message <8tko23$npi$0_at_pita.alt.net>...
>You might try the new_time function:
>
>new_time(date, 'this zone', 'output zone')
>
>select to_char(new_time(sysdate,'CST','GMT'),'MON DD YYYY HH24MI') from
>dual;
>
>PoutineQ wrote in message <8tkchq$s8u$1_at_nnrp1.deja.com>...
>>Hi,
>>
>>This is probably a simple question, but I haven't figured it out
>>yet. I would like to get the current time in GMT from Oracle (8,
>>HP-UX).
>>
>>In SYBASE, I was able to do "select getdate()", and I am trying to
>>port that code to Oracle.
>>
>>
>>The 'sysdate' function returns the local time. But, it does not
>>seem to return the time zone. The NEW_TIME() function also seems
>>to not be of much help, because I need to have the current
>>time zone, plus I would need to know if I'm in DST or not.
>>
>>Thanks,
>>
>>
>>Sent via Deja.com http://www.deja.com/
>>Before you buy.
>
>
Received on Mon Oct 30 2000 - 15:47:47 CST

Original text of this message

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