Question
Displaying Time Problem w/MySQL CFMX7
Greetings -
Using
-- MySQL
-- CFMX7
I have a report designed which collects the time the report was done. This
field is filled in by an individual. The form field is validated for time entry.
On the insert query, the input is coded as:
--> #CreateODBCTime(form.ReportTime)#
MySQL DB Field:
--> Name: ReportTime
--> Type: Time
--> Format: HH:MM:SS
--> Default: <NULL>
When I look at the individual record in DB I see the time as:
--> 15:21:00
When I output the time on a page (without formatting) I get this:
--> {ts '1970-01-01 00:00:00'}
When I output the time on a page (with formatting) I get this:
--> 00:00:00
What am I doing wrong? What am I missing?
Leonard B
Using
-- MySQL
-- CFMX7
I have a report designed which collects the time the report was done. This
field is filled in by an individual. The form field is validated for time entry.
On the insert query, the input is coded as:
--> #CreateODBCTime(form.ReportTime)#
MySQL DB Field:
--> Name: ReportTime
--> Type: Time
--> Format: HH:MM:SS
--> Default: <NULL>
When I look at the individual record in DB I see the time as:
--> 15:21:00
When I output the time on a page (without formatting) I get this:
--> {ts '1970-01-01 00:00:00'}
When I output the time on a page (with formatting) I get this:
--> 00:00:00
What am I doing wrong? What am I missing?
Leonard B
AdChoices