Sql date field is not getting saved exactly

I am trying to insert a date value '2010-03-14 02:00:00 AM'(Day light saving start time for 2010 year) in a datetime field of a table in sql server 2005. The date is saved as '2010-03-14 03:00:00 AM' The se开发者_JS百科rver is installed in US(EST time zone).

Can anyone tell me the reason why the date is saving differently?

Thanks Rupa

As the clock jumps from 0200 to 0300 one of these times does not exist.

Wikipedia says

A digital display of local time does not read 02:00 exactly at the shift, but instead jumps from 01:59:59.9 either forward to 03:00:00.0 or backward to 01:00:00.0.

In my view you should save all times in a database in GMT/UTC and only use the local time zone on display in the client - thus in the database all times will be monotonically increasing (that is the times will not jump back at the end of daylight saving)

GMT != UTC. GMT has Daylight Savings, UTC does not. Save your dates as UTC and you're good to go.

one point: GMT by definition does not change throughout the year: in Britain one exists either on GMT or on BST (British Summer Time).

That aside, I would recheck your time zone settings for your db and your server.