Home » SQL & PL/SQL » SQL & PL/SQL » Extract Timezone (merged)
Extract Timezone (merged) [message #382668] Fri, 23 January 2009 09:39 Go to next message
kumarbo7
Messages: 19
Registered: March 2008
Location: New Jersey
Junior Member
hi,

How to get exact Timezone like PST or PDT or EST using Oracle SQL.

Thanks,
Kumar
Re: get exact Timezone like PST or PDT or EST [message #382672 is a reply to message #382668] Fri, 23 January 2009 09:46 Go to previous messageGo to next message
BlackSwan
Messages: 25039
Registered: January 2009
Location: SoCal
Senior Member
to_char(sysdate,.........

[Updated on: Fri, 23 January 2009 09:46]

Report message to a moderator

Re: get exact Timezone like PST or PDT or EST [message #382676 is a reply to message #382668] Fri, 23 January 2009 09:50 Go to previous messageGo to next message
BlackSwan
Messages: 25039
Registered: January 2009
Location: SoCal
Senior Member
Stop spamming forum with same question!
Re: Extract timezone like PST or PDT from DBTIMEZONE [message #382679 is a reply to message #382668] Fri, 23 January 2009 09:55 Go to previous messageGo to next message
BlackSwan
Messages: 25039
Registered: January 2009
Location: SoCal
Senior Member
Are both SEARCH on this forum & GOOGLE broken for you?
Re: Extract timezone like PST or PDT from DBTIMEZONE [message #382680 is a reply to message #382668] Fri, 23 January 2009 10:06 Go to previous messageGo to next message
Michel Cadot
Messages: 64119
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
6 times you post the same question.
Topic is locked.
Don't abuse of our willingless to help.

Regards
Michel

[Updated on: Fri, 23 January 2009 10:07]

Report message to a moderator

Re: Extract timezone like PST or PDT from DBTIMEZONE [message #382733 is a reply to message #382680] Fri, 23 January 2009 15:36 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Topic unlocked, since the only way the OP would be able to get help is open yet another topic.
Re: Extract timezone like PST or PDT from DBTIMEZONE [message #382742 is a reply to message #382733] Sat, 24 January 2009 00:16 Go to previous message
Michel Cadot
Messages: 64119
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
...or PM or Report Message to get it unlocked.

Regards
Michel

[Updated on: Sat, 24 January 2009 00:18]

Report message to a moderator

Previous Topic: query
Next Topic: ORA-06502: PL/SQL: numeric or value error
Goto Forum:
  


Current Time: Tue Dec 06 06:37:27 CST 2016

Total time taken to generate the page: 0.10249 seconds