date time formatting

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
 
M

Mihai N.

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

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

DateTimePicker.Value Property is a DateTime, no need to go thru a
string and then parse it.
 
A

Andrew

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
 
M

Mihai N.

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top