Skip to main content
weezerboy
Inspiring
March 7, 2013
Answered

Concatate Date &Time values from a form & Do Insert

  • March 7, 2013
  • 1 reply
  • 602 views

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?

    This topic is closed to new replies. Start a new post to keep the conversation going.
    Correct answer duncancumming

    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

    1 reply

    duncancummingCorrect answer
    Participating Frequently
    March 7, 2013

    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

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices