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
Any help my dear cold fusion brothers?