I need functionality in a script that will enable me to insert dates into a table.
What SQL do I need to insert a date of the format
01/08/2010 00:00:00
where the date is the first day of the current month. What do I need to change order that I can specify the month value? Thanks
The accepted answer works, and may be faster, but SQL 2012 and above have a more easily understood method:
SELECT cast(format(GETDATE(), 'yyyy-MM-01') as Date)
Get First Day of Last Month
Select ADDDATE(LAST_DAY(ADDDATE(now(), INTERVAL -2 MONTH)), INTERVAL 1 DAY);
Get Last Day of Last Month
Select LAST_DAY(ADDDATE(now(), INTERVAL -1 MONTH));