Copy link to clipboard
Copied
I am trying to combine a date value and a time value from a form submission into one datetime value and then insert it into a SQL server 8 data table.
Here are the formats
Date : 03/07/2013
Time : 08:07 PM
So somehow I need to concatate these 2 items and then insert the combined value into a SQL server 8 data table. (datetime Data Type).
The inserted value should look like this
2013-03-07 20:07:00.000
Any help my dear cold fusion brothers?
You probably want to use ParseDateTime to turn your two strings (concatenate them) into one date object. See http://www.petefreitag.com/item/569.cfm for a useful example
Copy link to clipboard
Copied
You probably want to use ParseDateTime to turn your two strings (concatenate them) into one date object. See http://www.petefreitag.com/item/569.cfm for a useful example