Hi all!

I have a database which contains SMALLDATETIME-fields; the reason for SMALLDATETIME originally was that I'd like to save only a TIME-value in these fields.

The saving is handled with an stored-procedure (the parameter is of type SMALLDATETIME).
The value of the parameter is passed to the stored-proc from an aspx-webform (variable of type DATETIME converted to TOLONGTIMESTRING).

An SQL-Error is raised due to an datatype-mismatch.

I don't want to convert these SMALLDATETIME-fields in the database to CHAR-fields.

How can I save these 'times' into my SMALLDATETIME-fields???

Thanks for help!