`CURRENT_TIMESTAMP` not working for MySQL when creating records for datetime

dbcodeio / public

The Power of Databases, The Convenience of VS Code: All in One Place

29 stars 1 forks source link

`CURRENT_TIMESTAMP` not working for MySQL when creating records for datetime #27

Closed bilogic closed 1 month ago

bilogic commented 1 month ago

Can add this?

Both CURRENT_TIMESTAMP and CURRENT_TIMESTAMP() fails. Thanks.

mikeburgh commented 1 month ago

Ahh, good find.. yeah that's going to be tricky to find all the function keywords for various things.. and not wrap them.. Will get the obvious ones added this week!

mikeburgh commented 1 month ago

This has been released in 1.2.14.

When you edit a date column you will get an autocomplete for it, you can also enter it manually.. and it will be correctly handled in the change script that's applied to the database.