How to insert time 2009-09-22 18:09:37.881 in MYSQL My column type is DateTime

mysql

Solution

I got the issue resolved. The database was not allowing the insertion of time in millisecond. Please have a look at the lines, below:

CREATE TABLE MyTimeStamp(TimeData decimal(17,3));

INSERT INTO  MyTimeStamp(TimeData) values (20090922201843.426);

SELECT timestamp(TimeData) FROM MyTimeStamp;

OutPut:

2009-09-22 20:018:43.426000

Problem

How to insert time `2009-09-22 18:09:37.881` in mysql. Actually I can insert and retrieve the time `2009-09-22 18:09:37` in mysql but whenever I am trying to insert `2009-09-22 18:09:37.881` data did not get inserted in database. ``` 2009-09-22 18:09:37.881 -------> YYYY-MM-DD HH:MI:Sec.Ms ``` I have created a table using the below query ``` Create table XYZ(MyTime DateTime); ``` I tried the below query which worked fine ``` insert into XYZ(MyTime) values('2009-09-22 18:09:37'); ``` But I tried with the below query which did not work fine (Data didnot get insert in database) ``` insert into XYZ(MyTime) values('2009-09-22 18:11:38.881'); ```

Original source