MySQL Forums
Forum List  »  General

Re: Return of the milliseconds of a Date
Posted by: Claudinei Silva
Date: January 17, 2017 06:00PM

Friends / Peter

Could it be something connected to my Mysql which is version 5.5.20, since I used the commas below and is always returning 000000 in milliseconds?



SELECT DATE_FORMAT( NOW(3), '%a %e %b %y, %T %f' );
Tue 17 Jan 17, 20:53:42 000000
select DATE_FORMAT(SYSDATE(),'%Y%m%d%H%i%s%f');
20170117205342000000

Options: ReplyQuote


Subject
Written By
Posted
Re: Return of the milliseconds of a Date
January 17, 2017 06:00PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.