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: 64718
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: Mon Apr 24 22:11:41 CDT 2017

Total time taken to generate the page: 0.12847 seconds