blah blah blah is here! blah blah » Close

up0down
link

DateTime BirhtDate = dtBirthDate.Value.Date;


in the statement i'm trying to get the date from DateTimePicker in win app and pass it to a sql statement to be inter to database, but actually i'm getting the following :

System.Windows.Forms.DateTimePicker, Value: 31/12/1988 03:05:22


why i'm getting this rather than the only date i need to pass to the query to be put in the DB

!!

last answered one month ago

1 answers

up0down
link

You are using a datetime picker, if you only want the date, you need to specify the format Value.ToString("MMMM dd, yyyy") or whatever you prefer. More info here:

http://msdn.microsoft.com/en-us/library/8kb3ddd4.aspx

Feedback