什么是查询只显示日期和时间？ [英] what will be the query to show only date and only time?

问题描述

你好



我正在使用sql 2005.这是我的表信息：

hello

I am using sql 2005. here is my table information:

KICKOFF MTG     4/1/1995 12:00:00 AM    4/1/1995 12:00:00 AM
TECH SURVEY     4/2/1995 12:00:00 AM    5/1/1995 12:00:00 AM
USER MTGS       5/15/1995 12:00:00 AM   5/30/1995 12:00:00 AM
DESIGN WIDGET   6/1/1995 12:00:00 AM    6/30/1995 12:00:00 AM
CODE WIDGET     7/1/1995 12:00:00 AM    9/2/1995 12:00:00 AM

when我在输出节目下面运行了一个查询...

when i run a query stated below the output shows....

SELECT TASK, STARTDATE, ENDDATE ORIGINAL_END, DATEADD (year,2,ENDDATE) FROM PROJECT;

输出：

OUTPUT:

KICKOFF MTG     1995-04-01 00:00:00.000 1995-04-01 00:00:00.000 1997-04-01 00:00:00.000
TECH SURVEY     1995-04-02 00:00:00.000 1995-05-01 00:00:00.000 1997-05-01 00:00:00.000
USER MTGS       1995-05-15 00:00:00.000 1995-05-30 00:00:00.000 1997-05-30 00:00:00.000
DESIGN WIDGET   1995-06-01 00:00:00.000 1995-06-30 00:00:00.000 1997-06-30 00:00:00.000
CODE WIDGET     1995-07-01 00:00:00.000 1995-09-02 00:00:00.000 1997-09-02 00:00:00.000

现在我想知道什么是查询应该运行只显示日期和时间？



谢谢



RHRaj

Now i wanna know what will be the query should i run to show only date and for only time?

Thanks

RHRaj

推荐答案

检查此链接：日期格式Sql Server [ ^ ]

如果您只想要日期或时间，可以使用转换 [ ^ ]或演员

Check this link:Date Formats Sql Server[^]
If you want only Date or time, u can use convert[^] or Cast

Select CONVERT(VARCHAR(5),GetDate(),114) [Time HH:MM],Cast(Getdate() as Time) [Time]
Select CONVERT(VARCHAR(10), GETDATE(), 102) [Date YYYY.MM.DD],Cast(GetDate() as Date) [Date YYYY-MM-DD]

但推荐转换...

But Convert is Recommended...

对于SQL Server 2008及更高版本，您可以尝试CAST到DATE，如下所示< br $>

For SQL Server 2008 and above, you can try a CAST to DATE like below

SELECT CAST(GetDate() AS DATE) 

这篇关于什么是查询只显示日期和时间？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！