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
The best and easiest way to do this is to use:
SELECT DATEADD(m, DATEDIFF(m, 0, GETDATE()), 0)
Just replace GETDATE() with whatever date you need.