search

Home >Database >Mysql Tutorial >SQL取时间部分

SQL取时间部分

WBOY
WBOYOriginal
2016-06-07 14:56:361286browse

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：查看数据库中每张表自增种子值、增量值

Related articles

See more