OraFAQ Forum: SQL & PL/SQL » To convert from GMT time to CST time with Daylight time savings (merged 4)

Home » SQL & PL/SQL » SQL & PL/SQL » To convert from GMT time to CST time with Daylight time savings (merged 4) (SQL)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

To convert from GMT time to CST time with Daylight time savings (merged 4) [message #549313]

Thu, 29 March 2012 08:33

Mohammed Umar
Messages: 4
Registered: March 2012

Junior Member

Hi All,

My database stores time in GMT.. but my application stores time in CST..

I need to convert them from GMT to CST considering DAYLIGHT TIME SAVING as well by using Sql query..

please Help

Thanks in advance
Umar

[Updated on: Thu, 29 March 2012 08:41] by Moderator

Report message to a moderator

Re: To convert from GMT time to CST time with Daylight time savings (merged 4) [message #549321 is a reply to message #549313]

Thu, 29 March 2012 08:44

Michel Cadot
Messages: 68767
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

This has been asked last week, please search before posting.

http://www.orafaq.com/forum/mv/msg/179841/548182/102589/#msg_548182

Regards
Michel

Report message to a moderator

Re: To convert from GMT time to CST time with Daylight time savings (merged 4) [message #549324 is a reply to message #549321]

Thu, 29 March 2012 08:47

muralikri
Messages: 638
Registered: August 2011
Location: chennai

Senior Member

Check below link it's Useful..

http://www.techonthenet.com/oracle/functions/new_time.php

Report message to a moderator

Previous Topic:	Materialize hint and IOT
Next Topic:	Help with sql plus query

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Aug 31 22:16:14 CDT 2025