SELECT cast(getdate() as date);
返回结果:
SELECT CAST(getdate() AS TIME);
SELECT CAST(getdate() AS DATETIME)
SELECT CAST(getdate() AS DATETIME2)
SELECT CAST(getdate() AS DATETIMEOFFSET)
SELECT cast(getdate() as date);
返回结果:
SELECT CAST(getdate() AS TIME);
SELECT CAST(getdate() AS DATETIME)
SELECT CAST(getdate() AS DATETIME2)
SELECT CAST(getdate() AS DATETIMEOFFSET)