1 Reply Latest reply: Mar 13, 2014 12:59 AM by BKBK RSS

    Concatenate date time and update SQL datetime field

    weezerboy Community Member
    weezerboy Mar 11, 2014 10:19 AM

      I have a form that captures date and time in 2 separate fields data and time.

       

      I need to combine these fileds and UPDATE a SQL database (datetime field)

       

       

      The date field is passed like this  DSDATE={ts '2013-11-18 00:00:00'}

      The time field is passed like this   TIME_IN1=14:05

       

       

      How do I concatenate DSDATE AND TIME_IN1 so that I can insert like this 2013-11-18 14:05:00.000 ?

        • 1. Re: Concatenate date time and update SQL datetime field
          BKBK Community Member
          BKBK Mar 13, 2014 12:59 AM (in response to weezerboy)

          The easiest way may be the best. You judge.

           

          <cfset DSDATE = parsedatetime('2013-11-18')>

          <cfset  TIME_IN1="14:05">

           

          <cfset yr = year(DSDATE)>

          <cfset mnth = month(DSDATE)>

          <cfset d = day(DSDATE)>

          <cfset hr = listGetAt(TIME_IN1,1,":")>

          <cfset mn = listGetAt(TIME_IN1,2,":")>

          <cfset datetime=createdatetime(yr,mnth,d,hr,mn,0)>

           

          <cfoutput>#datetime#</cfoutput>