Date in T-SQL

最新推荐文章于 2022-08-03 14:31:47 发布

hjzdhr

最新推荐文章于 2022-08-03 14:31:47 发布

阅读量487

点赞数

文章标签： date output string

本文链接：https://blog.csdn.net/hjzdhr/article/details/4046664

版权

How can we only get date and change it to string format from T-SQL Date functions?

I googled a lot, but no luck, i didn't get the right answer, so i wrote these by myself...

Here are serveral formats:

My current date is 04/03/2009.

SELECT CONVERT(VARCHAR, current_timestamp - 1, 112) output: 20090402 SELECT CONVERT(VARCHAR, current_timestamp - 1, 101) output: 04/02/2009 SELECT CONVERT(VARCHAR, current_timestamp - 1, 102) output: 2009.04.02 SELECT CONVERT(VARCHAR, current_timestamp - 1, 103) output: 02/04/2009 SELECT CONVERT(VARCHAR, current_timestamp - 1, 104) output: 02.04.2009 SELECT CONVERT(VARCHAR, current_timestamp - 1, 105) output: 02-04-2009