day and date

Learn about day and date, we have the largest and most updated day and date information on alibabacloud.com

SQL Data Operations Basics (intermediate) 10

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 Get date

  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.

Tags Index:

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.