INSERT INTO T_TS_JBXX VALUES (TO_TIMESTAMP (' 2015-04-21 15:36:07:548000 ', '- DD YYYY - MM HH24: MI: SS: FF6'));
In mysql error, [Err] 1305 - FUNCTION dataleadin. TO_TIMESTAMP does not exist,
What do you need deal with timestamp values can be inserted into the mysql? Thank you,
CodePudding user response:
- is that ok?INSERT INTO T_TS_JBXX VALUES (' 2015-04-21 15:36:07:548000 ')
CodePudding user response:
Official API can only transfer timestamp time type in this mode,,,
The SELECT DATE_FORMAT (' 15:36:07 2015-04-21 ', '% % Y - c - h: % d % % I: % s') FROM DUAL;