Date Time format problem

[sh3rIIf]

When formatting date from a database it's returned as:

"2004/01/01 14:30", which is correct.

 

But when run from a different machine the time is messed up. Displayed as "02:30".

 

Checked regional settings on both machines and they match and formatting the time in .NET doesn't work. Can anyone help?

 

:mad: :mad:

[wessamzeidan]

May be their timezones are different

[sh3rIIf]

time zones and all other regional settings are the same on both machines.

[Denaes]

That's the same time, but in 24 hour time.

 

On my project, I had to use strings rather than Date or Time. VERY frustrating.

 

In Access, you can make Date/Time and set it to ONLY be date. Same with Time.

 

Fine, thats what I needed.

 

When I bring it over to VB.Net through a DataAdaptor, it comes through as 04/22/2004 00:00am, even though its ONLY the Date.

 

Because of issues like these I had to use strings to hold the date and times in a database. Very frustrating, but I need to have returned what I put in, not extra garbage. Someday I'd like to find a workaround :)

[Nerseus]

A general rule of thumb is store date/time (even if it's just a Date) in a DateTime variable in your program. Only when you want to display it do you format it. You can use the overrides on ToString() to "hardcode" a format if you like. For example, to not show the time portion:

string s = DateTime.Now.ToString("MM/dd/yyyy");

 

If you want a specific time format, or want to ensure that it's the same on every machine, it's probably best to use a "hardcoded" string format or use your own CultureInfo object to do the formatting.

 

-Nerseus