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

Eur0's profile image Eur0 posted 3 years 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 3 years 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 3 years 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.