以 RFC822 格式显示 CAST 日期时间

发布于 2024-10-03 05:58:54 字数 628 浏览 8 评论 0原文

我想使用以下 中的 RFC822 格式（例如：Fri, 19 Nov 2010 13:43:39）在 SQL 表中显示 CAST 日期时间SELECT（此处)

*_snip_*

,(Select Cast(Cast(FieldValue as nvarchar(max)) as DateTime) 
  from dbo.UserDefinedData where UserDefinedFieldId = 298 
  and UserDefinedRowId = item.UserDefinedRowId) as [pubDate]

下面的 SQL 位将以所需的格式检索当前日期。

我如何将其整合到上述陈述中（或者有更好的方法来实现我的目标）？

select left(datename(dw,getdate()),3)+', '+convert(varchar(20),getdate(),113)

原文

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 following SELECT (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)

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

聆听风音 2024-10-10 05:58:54

,(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]

,(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]

回复收藏 0 原文

~没有更多了~