Skip to main content
W
weezerboy
Inspiring
March 7, 2013
Answered

Concatate Date &Time values from a form & Do Insert

  • March 7, 2013
  • 1 reply
  • 595 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 has been closed for replies.
    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

    D
    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