Datetime problems between c# and sql
Posted on 2006-03-24
I'm currently working on an SQL DB where one of the fields(Start_Time) in my shift table is a datetime datatype.
When I bind the values in my Start_Time field to a combobox in my front end it retrieves the values in the following format : 2006/03/22 03:40:21 PM
However if I run a normal select * query on my Shift Table the same value as above is returned in the following format : 2006-03-22 15:40:21.000
What I'm trying to do is to use the selectd value in my combobox as a parameter in my storedprocedures but I am getting the [ 2006/03/22 03:40:21 PM]
value and not the [2006-03-22 15:40:21.000 ] value that my DB requires ! Please help!!
It`s driving me nuts!!