Time Converting Problem

Question

0.00/5 (No votes)

See more:

Hi all,

I m inserting date and time in database.

It's inserting fine, but time is inserting server time?

How can solve this.

I Have 04/09/2013, 11:13:00 AM
when I Inserting it's 04/09/2013 ,1:13:00 AM (us).

I want to Insert 04/09/2013 ,11:13:00 AM.

C#

//Im passing time like this
CultureInfo CI = new CultureInfo("en-US");
//puch.Time=04/09/2013, 11:13:00 AM 
obj.Scanned_Time = Convert.ToDateTime(Puch.Time.ToString("T", CI));
//in database storing like this 04/09/2013, 1:13:00 AM (us)
//here the date,time is two different fields

here the date,time is two different fields

So how can solve?

Thanks in advance............

Posted 19-Jun-13 3:47am

U@007

Updated 19-Jun-13 18:57pm

v5

Add a Solution

Comments

Pheonyx 19-Jun-13 9:53am

What code are you using to insert the data?

U@007 19-Jun-13 10:02am

see updated my code

Richard C Bishop 19-Jun-13 9:58am

Show the code that is inserting the DateTime into the database.

U@007 19-Jun-13 10:02am

see updated my code

4 solutions

Solution 2

Please check below links.

Converting Times Between Time Zones[^]

TimeZoneInfo.ConvertTime Method [^]

Posted 19-Jun-13 3:56am

Mahesh Bailwal

Solution 3

Why are you creating a CultureInfo of type US? I have no idea if this will convert your time or not, but it is not something I would do.

Personally I would just do this:

C#

obj.Scanned_Time = Puch.Time;

without the culture info.

Posted 19-Jun-13 4:20am

Pheonyx

Comments

U@007 20-Jun-13 0:45am

Hi Pheonyx,
the date,time two is separate fields.
actually server time is us.that's y we are passing CultureIinfo.

Pheonyx 20-Jun-13 3:06am

I'm afraid that without seeing more of your code I cannot explain it then. This is not something I've seen occurring before.

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)

Ravi Kumar Shakya · Accepted Answer · 2013-06-19T03:55:00

Solution 1

If you have cloud Access on server just change the Time Format and set the time as your desired format because by default it will take Server Date Time. or

If you don't have cloud access on server, You can Insert it after deducting 120 mins for your desired time.

Posted 19-Jun-13 3:55am

Ravi Kumar Shakya

Comments

U@007 20-Jun-13 5:05am

Thank you ravi
:)

U@007 · Accepted Answer · 2013-06-19T23:04:00

Solution 4

Finally I Solved
As I know that, my system time changed to server time. Now working fine.

Thanks for all....... who are given suggestions?

Posted 19-Jun-13 23:04pm

U@007

Comments

Richard C Bishop 26-Jul-13 18:08pm

You are on the verge of abuse by posting comments as solutions to your own questions and accepting them as answers. Please stop.