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: 68643
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
NEW_TIME
FROM_TZ

Regards
Michel

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Apr 23 07:07:27 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.