1 Reply Latest reply on Mar 7, 2013 1:26 AM by duncancumming

    Concatate Date &Time values from a form & Do Insert

    weezerboy Level 1

      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?