Question

我有兴趣将日期改为服务器。我在此简单地问:

SELECT 
ENTERED_DATE as DATE
ENTERED_DATE as NEXT_DATE
FROM SOMETABLE

DATE                          NEXT_DATE
12/1/2010 12:30:00 AM         12/1/2010 12:30:00 AM
12/1/2010 4:00:00 AM           12/1/2010 4:00:00 AM
12/1/2010 9:00:00 AM           12/1/2010 9:00:00 AM

我希望我取得这样的结果:

 DATE                          NEXT_DATE
 12/1/2010 12:30:00 AM         (null)
 12/1/2010 4:00:00 AM         (null)
 12/1/2010 9:00:00 AM         (null)

我如何能够这样做?

Answer 1

How about:

SELECT 
ENTERED_DATE as DATE
CONVERT(datetime, NULL) as NEXT_DATE
FROM SOMETABLE

Answer 2

SELECT ENTERED_DATE as DATE, CAST(NULL AS DATETIME) as NEXT_DATE 
FROM SOMETABLE

Answer 3

如果我完全理解这个问题,你能否这样做?

拉丁美洲和加勒比国家:

友情链接