date time formatting

  • Thread starter Thread starter Andrew
  • Start date Start date
A

Andrew

hi,

my sp takes datetime in 'yyyyMMdd HH:mm:ss' format.

however my c# datetimepicker takes 'dd/MM/yy HH:mm:ss' format.

how do i convert/parse the datetime value from the datetimepicker to the sp
datetime format ? I've tried:
eg.
IFormatProvider culture = new CultureInfo("en-US", true);
DateTime dt3 = DateTime.ParseExact("20080722 10:00:00" , "yyyyMMdd
HH:mm:ss", culture);

No matter what datetime format I pass in, I will always get a "dd/MM/yyyy
HH:mm:ss" format in return, which is not what I want to get. Is my culture
wrong ?

Any advice is appreciated.
Thanks in advance.

regards,
Andrew
 
my sp takes datetime in 'yyyyMMdd HH:mm:ss' format.

however my c# datetimepicker takes 'dd/MM/yy HH:mm:ss' format.
Click to expand...

DateTimePicker.Value Property is a DateTime, no need to go thru a
string and then parse it.
 
Hi thanks for your reply.

The sp takes datetime in format 'yyyyMMdd HH:mm:ss'
The datetime picket produces a value in format 'dd/MM/yyyy HH:mm:ss'
I just modified the sp to take in a varchar(17) and cast it to a datetime
format.

cheers
Andrew
 
The datetime picket produces a value in format 'dd/MM/yyyy HH:mm:ss'
Make sure that the result is 'dd/MM/yyyy HH:mm:ss' even for non-US
systems, otherwise you might have a nasty surprise later on.
 
Back
Top