HI All

I have a form which asks users for a date and time with a series of drop downs, ( this date and time will be in the future so i dont want to use NOW)

What I do is take the form values from the post data and build a string which is the date and time in this format

12/01/2005 09:55:00

with this string i then do an insert, however the data type is causing problems, as I am trying to pass a string into a stored proc to insert the value into a field with datatype DateTime.

What is the best way to get this into a format which I will be able to insert into my DateTime field.

Changing the data type of this field in my DB is not an option.

platform: ASP & SQL server 2000

Many Thanks

I suppose that 12/01/2005 09:55:00 is the format that u have in ASP.
But when u want to add it to database,then you have to conver it into the format that is required by the database(Here:SQL Server)

just use convert(datetime,'12/01/2005 09:55:00') in the sql insert query.

It will work.



Ashwin S.Kenkare
Programmer
CMI