SQL Server 2005中的日期格式 [英] date formate in sql server 2005

问题描述

我想要这样的数据表格.
"2011年2月8日，星期二，9:06:21 AM""



如何将(2011-04-07 15:17:18.460)转换为(2011年2月8日，星期二，9:06:21 AM)

i want to get the data form table like this.
"Tuesday, February 08, 2011 9:06:21 AM" "



how to convert (2011-04-07 15:17:18.460) to (Tuesday, February 08, 2011 9:06:21 AM )

推荐答案

SQL Server帮助程序-提示和技巧-日期格式 [

尝试以下操作:

Try this:

declare @D as DateTime
set @D = GETDATE()
SELECT DATENAME(weekday, @d) + ', '  + CONVERT(NVARCHAR(MAX), @D, 109)

它将返回

It will return

Wednesday, 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())

这篇关于SQL Server 2005中的日期格式的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！