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: 68787
Registered: March 2007
Location: Saint-Maur, France, https...
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: Sun Nov 08 17:23:01 CST 2026
.:: Forum Home :: Wiki Home :: Contact :: Privacy ::.