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

renerlemes's profile image renerlemes posted 3 years ago in General Permalink

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

ansgar's profile image ansgar posted 3 years ago Permalink

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

renerlemes's profile image renerlemes posted 3 years ago Permalink

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

ansgar's profile image ansgar posted 3 years ago Permalink

Oh, ok. So everything's fine here?

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