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: 334
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: 64111
Registered: March 2007
Location: Nanterre, France, http://...
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: 334
Registered: August 2006
Senior Member
Thanks a Lot.
Previous Topic: Date issue
Next Topic: Order By Decode Variable UNION Issue!!
Goto Forum:
  


Current Time: Mon Dec 05 19:28:55 CST 2016

Total time taken to generate the page: 0.12541 seconds