SQL取日期部分
- WBOYOriginal
- 2016-06-07 14:56:401220browse
SQL取日期部分 无 convert(varchar(10),getdate(),120) convert(varchar(10),getdate(),23) SELECT CAST(GetDate() as DATE)SELECT CONVERT(DATE,GetDate())
SQL取日期部分
convert(varchar(10),getdate(),120) convert(varchar(10),getdate(),23)
SELECT CAST(GetDate() as DATE) SELECT CONVERT(DATE,GetDate())
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：刷新SQL Server所有视图、函数、存储过程Next article：查询一个表内相同纪录