View Single Post
  #1 (permalink)  
Old June 7th, 2006, 01:58 AM
rijahs rijahs is offline
Registered User
 
Join Date: Jun 2006
Location: bangalore, karnataka, India.
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default SQL Database storing entries in GMT Time

Hi,

I am storing the events from a couple of servers in the SQL Database and the SQL Database stores the data in the GMT Time. I have checked the servers and all the servers are in the local time(+5:30). When I use the SQL Query to check the time, the entries are being stored in the GMT Time rather than the local time which is creating a lot of problems for me. For some strange reasons, some of the entries show the right local time as well. Kindly advice how to resolve this problem.

Thanks a lot in advance.

Reply With Quote