T -SQL (Transact-SQL). SELECT DATEPART(DAYOFYEAR, SYSDATETIME()) or. SELECT datediff(day,CAST(datepart(year,getdate()) AS CHAR(4)) + '-01-01',getdate()+1) AS ...
確定! 回上一頁