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!
robert.oh.