Home » SQL & PL/SQL » SQL & PL/SQL » Timezone issue with the date field (Oracle 10gR2)
Timezone issue with the date field [message #392759] Thu, 19 March 2009 04:03 Go to next message
srinivas.k2005
Messages: 404
Registered: August 2006
Senior Member
Hi,

I have a date field with datatype as DATE in the database column.
Default the database shows the PST time, how can i display the time of EST.

I checked the Format Models document for date and i was not clear with the TZD,TZH,TZM usage.

Thanks,
Srinivas


Re: Timezone issue with the date field [message #392761 is a reply to message #392759] Thu, 19 March 2009 04:08 Go to previous messageGo to next message
Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
NEW_TIME

Regards
Michel
Re: Timezone issue with the date field [message #392764 is a reply to message #392761] Thu, 19 March 2009 04:16 Go to previous message
srinivas.k2005
Messages: 404
Registered: August 2006
Senior Member
Thanks a Lot.
Previous Topic: Date issue
Next Topic: Order By Decode Variable UNION Issue!!
Goto Forum:
  


Current Time: Tue Feb 11 05:31:18 CST 2025