取出當日日期之SQL語法

1.Oracle
    Select trunc(sysdate) from dual

2.SQL Server
    (1)先轉成Varchar再轉回Datetime
        Case(Convert(VARCHAR, getdate(),101) as datetime)

    (2)先轉成浮點數後取整數位，再轉回Datetime
        Case(Floor(Cast(getdate() as float)) as datetime)