更新时间:2023-01-29 13:18:36
SQL Server帮助程序-提示和技巧-日期格式 [尝试以下操作:
Try this:
declare @D as DateTime set @D = GETDATE() SELECT DATENAME(weekday, @d) + ', ' + CONVERT(NVARCHAR(MAX), @D, 109)
它将返回
It will returnWednesday, Feb 15 2012 7:43:41:067AM
这将尽可能地接近您,而无需进行任何调整.
老实说,我会在我的应用程序代码中执行此操作,而不是在SQL中执行此操作:它更加灵活和可国际化.Which is about as close as you will get without some tweaking.
To be honest, I would do this in my application code, rather than SQL: it is a lot more flexible and internationalizable.
您好,
请参考此 http://msdn.microsoft.com/en-us /library/ms174395%28v=sql.90%29.aspx [Hello,
Please refer this http://msdn.microsoft.com/en-us/library/ms174395%28v=sql.90%29.aspx[^]
A small suggestion
select DATENAME(dw,GETDATE()) SELECT DATENAME(MONTH,GETDATE()) SELECT DAY(GETDATE()) SELECT YEAR(GETDATE())