Datetime Issue while updating record

Question

0.00/5 (No votes)

See more:

Hello All,
I trying to save record from mobile application and the format in which data is send from device is

2012-10-09T13:04:54+05:30

, and in phone service that saves the record in database i am parsing the data using DateTime.Parse

(date1)

in c#. but when data is saved in sql server it is saving 1 day back (like : if a send 10/9/2012 it saves 10/8/2012).

i tried to implement ( as my database server is in US)

TimeZoneInfo.ConvertTime(date1, TimeZoneInfo.FindSystemTimeZoneById("Eastern Standard Time"));

But it did't work for me. Can anybody suggest me what is going wrong.

Thanks

Posted 9-Oct-12 1:51am

Member 4531085

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Teenustar · Answer 1 · 2012-10-09T06:28:00

You should be updating the time using UTC (Coordinated Universal Time)
It is the standard international time in which all timezones are expressed as offset of.
To compute local time from the UTC, add the timezone offset and then add an additional hour if daylight savings time is in effect.

To Get the Current time in UTC

C#
DateTime currentTime = DateTime.UtcNow; 

SQL 
DECLARE @currentTime datetime
SET @currentTime = GETUTCDATE()

To convert UTC to current time

C#

DateTime currentServerTime = DateTime.UtcNow.ToLocalTime();
currentServerTime = ((DateTime) Eval("YourDate")).ToLocalTime();