Learn about day and date, we have the largest and most updated day and date information on alibabacloud.com
Data operation date and time Date and time functions are useful for building a site. The owner of the site is often interested in when the data in a table is updated. With date and time functions, you can track changes in a table at the millisecond
SQL statement gets a specific date 1. The first day of one months Select DATEADD (mm, DATEDIFF (Mm,0,getdate ()), 0) 2. Monday of this week Select DATEADD (wk, DATEDIFF (Wk,0,getdate ()), 0) 3.