如何在日期时间内省略“秒” [英] How to leave out 'seconds' appearing in datetime

问题描述

在我的gridview中，我想省略'秒'。下面是我的代码：

In my gridview I would like to leave out 'seconds' appearing. Hereunder is my code:

SqlDataAdapter da = new SqlDataAdapter("seLECT YEAR(startdt) AS [Year],MONTH(startdt) AS [Month], DAY(startdt) as [day],cast(startdt as datetime) as [datetime], COUNT(*) from visit Group By YEAR(startdt), MONTH(startdt),day(startdt),startdt", con);

<asp:BoundField DataField="datetime" HeaderText="Date-Time"  />

谢谢。

Thanks.

推荐答案

请看这个链接：



从Sql Server中的时间戳中删除第二个 [ ^ ]



我认为你有同样的问题。

希望它有所帮助！ ：）

Hi, Please see this link:

Remove second from timestamp in Sql Server[^]

I think you have the same question.
Hope it helps! :)

检查这个

Hi ,
Check this

<asp:boundfield datafield="datetime" headertext="Date-Time" dataformatstring="{0:d}" xmlns:asp="#unknown" />

http://msdn.microsoft.com/en-us/library/system.web.ui.webcontrols.boundfield.dataformatstring.aspx [ ^ ]

最好的问候

M.Mitwalli

http://msdn.microsoft.com/en-us/library/system.web.ui.webcontrols.boundfield.dataformatstring.aspx[^]
Best Regards
M.Mitwalli

这篇关于如何在日期时间内省略“秒”的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！