SQL取时间部分
- WBOYOriginal
- 2016-06-07 14:56:361263browse
SQL取时间部分 无 SELECT CONVERT(varchar(8),GetDate(),8)SELECT CONVERT(varchar(8),GetDate(),24)SELECT CONVERT(varchar(8),GetDate(),108) SELECT CONVERT(time,GetDate())SELECT CAST(GetDate() AS time)
SQL取时间部分SELECT CONVERT(varchar(8),GetDate(),8) SELECT CONVERT(varchar(8),GetDate(),24) SELECT CONVERT(varchar(8),GetDate(),108)
SELECT CONVERT(time,GetDate()) SELECT CAST(GetDate() AS time)
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：查看数据库中每张表自增种子值、增量值