sql-several date functions

/*     personnel: LDH    function: sql-Several date functions    */ use   TSQLFundamentals2008; GO SELECT OrderID,    OrderDatefrom Sales.orders;

SELECT TOP(8) OrderID, OrderDate fromsales.ordersWHEREOrderDate> '20080301';SELECT TOP(8) OrderID, OrderDate fromsales.ordersWHEREOrderDate> CAST('20080301'  as DATETIME);

--Month Day time secondsSELECT DATEPART( Year,GETDATE()) as 'years',    DATEPART(MONTH,GETDATE()) as 'Month',    DATEPART( Day,GETDATE()) as 'Day',    DATEPART(HOUR,GETDATE()) as 'when',    DATEPART(MINUTE,GETDATE()) as 'points',    DATEPART(SECOND,GETDATE()) as 'seconds';--a few specialSELECT DATEPART(DayOfYear,GETDATE()) as 'days from the beginning to the present',    DATEPART(WEEKDAY,GETDATE()) as 'the day of the week',    DATEPART(WEEK,GETDATE()) as 'The first week of this year';

SELECT GETDATE() as 'currentdate',    DATEADD(MONTH,2,GETDATE()) as 'futuredate';SELECT GETDATE() as 'currentdate',    DATEADD( Year,2,GETDATE()) as 'futuredate';

--Calculate personal AgeSELECT DATEDIFF( Year,'19890125','20180720') as 'my age.';--anniversary of the founding of ChinaSELECT DATEDIFF( Year,CAST('19491001'  as DATETIME),GETDATE()) as 'anniversary of the founding of China';

sql-several date functions