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.

COALESCE function and 0000-00-00' dates in Heidi

Eur0's profile image Eur0 posted 4 months ago in General Permalink

I am trying to impute some NULL dates using the COALESCE function, but it does not seem to be a functional part

Eur0's profile image Eur0 posted 4 months ago Permalink

Any ideas on how best to impute a '0000-00-00' date with a different value? I am a bit rusty on date manipulation in SQL, so any help would be appreciated!

ansgar's profile image ansgar posted 4 months ago Permalink

Using a query? You should just update the field with a date quoted like a string:

UPDATE foo SET bar='2021-05-06' WHERE whatever

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




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.