Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here
Dec 18, 2018 04:38 AM
I get an error when I use DATEADD with a date I formated in another field with DATETIME_FORMAT.
Is there a way to “unformat” a date?
Dec 19, 2018 05:07 AM
DATETIME_FORMAT()
returns a string, so you can’t use then DATEADD()
. You can:
DATEADD()
before the DATETIME_FORMAT()
DATETIME_PARSE()
to get back a date, and then use the DATEADD()