Answered
"2:00 am" is an invalid date or time string.
Hello.
I'm trying to (parsed down to this for easy reading):
<cfquery name="rsInsertEventInfo" datasource="#application.dsn#">
INSERT INTO et_events
(
event_start_time
)
VALUES
(
...
)
</cfquery>
For "..." above, I've tried:
<cfqueryparam cfsqltype="CF_SQL_TIME" value="#timeformat(attributes.txt_event_start_time, "hh:mm:ss")#">
and
<cfqueryparam cfsqltype="CF_SQL_TIME" value="#attributes.txt_event_start_time#">
But I keep getting:
"2:00 am" is an invalid date or time string (assuming I select 2:00 am from the js timepicker)
Do I need to switch to using a TIMESTAMP column type (instead of TIME)? Or is there a way to make this work?
Thank you for suggestions!
I'm trying to (parsed down to this for easy reading):
<cfquery name="rsInsertEventInfo" datasource="#application.dsn#">
INSERT INTO et_events
(
event_start_time
)
VALUES
(
...
)
</cfquery>
For "..." above, I've tried:
<cfqueryparam cfsqltype="CF_SQL_TIME" value="#timeformat(attributes.txt_event_start_time, "hh:mm:ss")#">
and
<cfqueryparam cfsqltype="CF_SQL_TIME" value="#attributes.txt_event_start_time#">
But I keep getting:
"2:00 am" is an invalid date or time string (assuming I select 2:00 am from the js timepicker)
Do I need to switch to using a TIMESTAMP column type (instead of TIME)? Or is there a way to make this work?
Thank you for suggestions!
AdChoices