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?