sql server convert date to first day of month?Advertisement
Get First Day of the Month Function. Getting the first day of the month is straight-forward. It's a matter of replacing the day portion of the given date with 1. - read more
Hi, I have a date/time field called ConsultDate. In my query, I want to convert this into the first day of the month it fals in. So if the consult date is 11/14/2011 the converted date would be 11/1/2011. - read more
Please vote if the answer you were given helped you or not, thats the best way to improve our algorithm. You can also submit an answer or check other resources.