Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

Field Date with automatic value wrong

22 posts

renerlemes posted 7 years ago in General

When I set the type field as Date e then I insert a value in Date Format, when I run a query using DATE_FORMAT(FIELD,"%Y-%m-%d %H:%m:%s") the minute is 09. It's wrong, the Hour, Minute and Seconds is 00:00:00

9920 posts

ansgar posted 7 years ago

Please post the exact raw value of your field, and the data type of that column.

22 posts

renerlemes posted 7 years ago

ansgar, sorry! I put DATE_FORMAT using %m for minute, when should be %i.

9920 posts

ansgar posted 7 years ago

Oh, ok. So everything's fine here?

Please login to leave a reply, or register at first.