SQL中只截取日期的日期部分和日期的时间部分

 

SQL Server 中截取日期的日期部分：
print convert(varchar(10),getdate(),120)

SQL Server 中截取日期的时间部分：
print convert(varchar(8),getdate(),108)


SELECT ProductName, CONVERT(datetime, BeginTime,108) AS BeginTime,
      CONVERT(datetime, EndTime,108) AS EndTime, CONVERT(datetime,
      CONVERT(Nvarchar, GETDATE(),108)) AS NOWTIME
FROM Products
WHERE (CONVERT(datetime, BeginTime) < CONVERT(datetime, CONVERT(Nvarchar,
      GETDATE(),108))) AND (CONVERT(datetime, EndTime,108) > CONVERT(datetime,
      CONVERT(Nvarchar, GETDATE(),108)))
ORDER BY EndTime DESC, BeginTime

 

 

SELECT ProductName, CONVERT(datetime, BeginTime, 108) AS BeginTime,
      CONVERT(datetime, EndTime, 108) AS EndTime, CONVERT(datetime,
      CONVERT(Nvarchar, GETDATE(), 108)) AS NOWTIME, ID
FROM Products
WHERE (CONVERT(datetime, BeginTime) < CONVERT(datetime, CONVERT(Nvarchar,
      GETDATE(), 108))) AND (CONVERT(datetime, EndTime, 108) > CONVERT(datetime,
      CONVERT(Nvarchar, GETDATE(), 108)))
ORDER BY EndTime DESC, BeginTime