在sql中转换日期.......................... [英] Convert date in sql ..........................
问题描述
嗨朋友
i有一个日期,如25/12/2014,我的问题是我想在2014年decte如何在sql server中成为可能
感谢advance
select substring(< span class =code-keyword> CONVERT ( VARCHAR ( 12 ),COLUMNNAME, 106 ), 3 , 10 )< span class =code-keyword> AS date 来自 YOURTABLE
您想要的日期格式 [< a href =http://www.sql-server-helper.com/tips/date-formats.aspxtarget =_ blanktitle =新窗口> ^ ]
选择 co nvert ( nvarchar (max),getdate(), 106 )
选择子串( convert ( nvarchar (max),getdate(), 106 ), 3 , 100 )
尝试
SELECT FORMAT(现在(),' MMM YYYY') AS ConvertedColumnName
FROM TableName;
注意:更改Now()函数为Datetime值
保留以下链接作为所有日期转换的参考。
http://www.sql-server-helper.com/sql-server-2012/format-function-vs-convert-function.aspx [ ^ ]
Hi friends
i have one date like 25/12/2014 and my problem is i want to dec 2014 formate how to possible in sql server
thanks to advance
select substring(CONVERT(VARCHAR(12), COLUMNNAME, 106),3,10) AS date from YOURTABLE
select convert(nvarchar(max),getdate(),106)
select substring(convert(nvarchar(max),getdate(),106),3,100)
Try
SELECT FORMAT(Now(),'MMM YYYY') AS ConvertedColumnName FROM TableName;
Note : Change the Now() function to the Datetime value
Keep the below link as a reference for all kind of Date Conversions.
http://www.sql-server-helper.com/sql-server-2012/format-function-vs-convert-function.aspx[^]
这篇关于在sql中转换日期..........................的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!