DATEADD (Transact-SQL)
DATEADD (Transact-SQL)
This function adds a specified number value (as a signed integer) to a specified datepart of an input date value, and then returns that modified value.
See Date and Time Data Types and Functions (Transact-SQL) for an overview of all Transact-SQL date and time data types and functions.
DATEADD (datepart , number , date )
datepart
The part of date to which DATEADD adds an integer number. This table lists all valid datepart arguments.
day的缩写是dd或d
温馨提示: 本文由Jm博客推荐，转载请保留链接: https://www.jmwww.net/SQL/21929.html
- 上一篇：毕设的学习（14）MySQL批量更新数据
- 下一篇：mysql比较常用到的一些操作
