以RFC822格式显示CAST日期时间 [英] Displaying a CAST datetime in RFC822 Format
本文介绍了以RFC822格式显示CAST日期时间的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我想在SQL表中使用RFC822格式显示 CAST
datetime(例如: Fri,2010年11月19日13:43:
SELECT
(此处)
* _ snip_ *
,(选择Cast(Cast(FieldValue as nvarchar(max))as DateTime)
from dbo.UserDefinedData where UserDefinedFieldId = 298
和UserDefinedRowId = item.UserDefinedRowId)as [ pubDate]
下面的SQL位将以所需的格式检索当前日期。
如何将它集成到上述语句中(或者是否有更好的方法来实现我的目标)?
select left(datename(dw,getdate()),3)+','+ convert(varchar(20),getdate(),113)
解决方案
转换(fieldvalue as nvarchar(50))),3)+','+
从dbo.UserDefinedData convert(varchar(20),cast(fieldvalue as nvarchar(50)), UserDefinedFieldId = 298
和UserDefinedRowId = item.UserDefinedRowId)as [pubDate]
I would like to display a
CAST
datetime in an SQL table using the RFC822 format (ex:Fri, 19 Nov 2010 13:43:39
) from the followingSELECT
(part of a larger statement found here)*_snip_* ,(Select Cast(Cast(FieldValue as nvarchar(max)) as DateTime) from dbo.UserDefinedData where UserDefinedFieldId = 298 and UserDefinedRowId = item.UserDefinedRowId) as [pubDate]
The bit of SQL below will retrieve the current date in the desired format.
How can I integrate it into the above statement (or is there a better way to achieve my goal)?
select left(datename(dw,getdate()),3)+', '+convert(varchar(20),getdate(),113)
解决方案,(Select left(datename(dw,cast(fieldvalue as nvarchar(50))),3)+', '+ convert(varchar(20),cast(fieldvalue as nvarchar(50)),113) from dbo.UserDefinedData where UserDefinedFieldId = 298 and UserDefinedRowId = item.UserDefinedRowId) as [pubDate]
这篇关于以RFC822格式显示CAST日期时间的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文