Hello, how can I convert a date to first be the first of the month and then to a string. For example:
2023-03-16 to 2023-03-01
Thank you in advance!
Take a look at some of the common date routines here for this sort of thing.
As for making it a string, let the front end do that, visualisation things like that should be in the GUI not in the DB.
Dates should be treated as dates, and not strings.
17 People are following this question.