CODEWITHSUNDEEP
mysql
Anthony
Anthony

Reputation: 35928

How to get milliseconds in mysql

I have a column with DATETIME type. It seems to be storing data in date and time but not in milliseconds.

What can I do to ensure milliseconds are captured in addition?

Example:

insert into mytable (datecreated) values (now());

select * from mutable; -- fetches 2014-10-06 17:44:19 date followed by hr:min:sec but not millisecond

Upvotes: 1

Views: 612

Answers (1)

Toneek Muz
Toneek Muz

Reputation: 11

http://dev.mysql.com/doc/refman/5.0/en/datetime.html However, microseconds cannot be stored into a column of any temporal data type. Any microseconds part is discarded.

You can store your date as string.

Upvotes: 1

Related Questions