| Subject | Time format for insertion into table |
|---|---|
| Author | Clay Shannon |
| Post date | 2005-02-11T19:24:12Z |
I'm trying to:
INSERT INTO SCHEDPOSITIONS
VALUES (7, 1, '7:00:00 AM', '3:00:00 PM', 'Day East CNA', 0, 'A');
But get "conversion error from string" on the '7:00:00 AM' value. This
column is of TIME type. Do I need to cast it, or.?
Clay Shannon,
Dimension 4 Software
[Non-text portions of this message have been removed]
INSERT INTO SCHEDPOSITIONS
VALUES (7, 1, '7:00:00 AM', '3:00:00 PM', 'Day East CNA', 0, 'A');
But get "conversion error from string" on the '7:00:00 AM' value. This
column is of TIME type. Do I need to cast it, or.?
Clay Shannon,
Dimension 4 Software
[Non-text portions of this message have been removed]