Home » Other » General » Function to get GMT time (Oracle 9i)
Function to get GMT time [message #289943] Wed, 26 December 2007 16:23 Go to next message
dasgupta.amitava@gmail
Messages: 32
Registered: November 2007
Member
Hi,
Is there any function in Oracle 9i to get the sysdate in GMT? If not atleast any function to get the sys DBTimezone in the format: EST, EDT, etc.??


Thanks in advance
Amitava.....

[Updated on: Wed, 26 December 2007 16:23]

Report message to a moderator

Re: Function to get GMT time [message #290012 is a reply to message #289943] Thu, 27 December 2007 02:02 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
NEW_TIME
FROM_TZ

Regards
Michel

Previous Topic: Versions/licenses - Choosing an Oracle Database
Next Topic: Tools for automatically filling tables
Goto Forum:
  


Current Time: Sat Dec 10 14:36:59 CST 2016

Total time taken to generate the page: 0.10518 seconds