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!
asked
Date conversion
Take a look at some of the common date routines here for this sort of thing.
https://www.sqlservercentral.com/blogs/some-common-date-routines
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.
