SQL日期

DECLARE @nowDate DATETIME
SET @nowDate=GETDATE()

SELECT  @nowDate AS '当前日期',
        CONVERT(VARCHAR(10),DATEADD(DAY,-1,@nowDate),120) AS '昨天日期', 
        CONVERT(VARCHAR(10),DATEADD(DAY,0,@nowDate),120)  AS '今天日期', 
        CONVERT(VARCHAR(10),DATEADD(DAY,1,@nowDate),120)  AS '明天日期'

 

 

SELECT
    GETDATE()               AS [GetDate],
    CURRENT_TIMESTAMP       AS [Current_TimeStamp],    
    SYSDATETIME()           AS [SYSDateTime],
    GETUTCDATE()            AS [GetUTCDate],
    SYSUTCDATETIME()        AS [SYSUTCDateTime],
    SYSDATETIMEOFFSET()     AS [SYSDateTimeOffset]

 

 

SELECT  GETDATE() AS '当前日期',
        CONVERT(VARCHAR,GETDATE(),120) AS '120',
        CONVERT(VARCHAR,GETDATE(),111) AS '111',
        CONVERT(VARCHAR,GETDATE(),112) AS '112',
        CONVERT(VARCHAR,GETDATE(),108) AS '108'