如何仅在数据库中获取日期格式 [英] how to get date format only in data base
问题描述
如何仅在数据库中获取日期格式:下面是我的代码,我只需要报告日期的数据格式,但它显示数据和时间格式
< pre lang =sql> 选择 A.DocEntry 作为 ' CallId',B.UserName As ' UserName',C.ClientName As ' ClientName',A.RpDateTime As ' ReportedDate',
A.CallSubject As ' Subject',A.CallDescription As ' IssueDetails',A.Priority,A.CallType,A。[Status],
DATEDIFF(Day,A.RpDateTime,GetDate()) As < span class =code-string>' 年龄',D.ConsName AS < span class =code-string>' ActionTakenBy',A.RspDateTime As < span class =code-string>' ActionTakenat',A.FeedBack
From BUSON_CALLLOG A
内部 加入 BUSON_USER B 开 A.UserId = B.UserId
LEFT OUTER JOIN BUSON_CONSULTANT D ON A.ActBy = D.UserId
内部 加入 BUSON_CLIENT C On B.ClientId = C.ClientId
http://www.sql-server-helper.com/tips/date-formats.aspx [<一个href =http://www.sql-server-helper.com/tips/date-formats.aspxtarget =_ blanktitle =新窗口> ^ ]
尝试转换为日期...选择 Cast(Getdate() as 日期)
最好检查answer1中的链接......这非常有用.. ..
how to get date format only in data base: below is my code I need only for data formats in Reported Date but it showing data and time format
Select A.DocEntry As 'CallId', B.UserName As 'UserName', C.ClientName As 'ClientName', A.RpDateTime As 'ReportedDate',
A.CallSubject As 'Subject', A.CallDescription As 'IssueDetails', A.Priority, A.CallType, A.[Status],
DATEDIFF(Day, A.RpDateTime, GetDate()) As 'Age',D.ConsName AS 'ActionTakenBy', A.RspDateTime As 'ActionTakenat' ,A.FeedBack
From BUSON_CALLLOG A
Inner Join BUSON_USER B On A.UserId = B.UserId
LEFT OUTER JOIN BUSON_CONSULTANT D ON A.ActBy=D.UserId
Inner Join BUSON_CLIENT C On B.ClientId = C.ClientId
http://www.sql-server-helper.com/tips/date-formats.aspx[^]
Try Casting as Date...Select Cast(Getdate() as Date)
Better to Check the link in answer1... it's Very helpful....
这篇关于如何仅在数据库中获取日期格式的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!