SQL Server Date Query tips

CONVERT (varchar), Sendtime, 23) –-sql field Sendtime parameters

Selectdatename (Weekday,getdate ());--return to the current week

Selectdatepart (Month,getdate ());--return to the current month

Selectday (GetDate ());--Returns the current date number of days

Select how many weeks of the year =datename (week, ' 2004-10-15 ')

, today is a few weeks =datename (weekday, ' 2004-10-15 ')

Selectyear (GetDate ());--Returns the current date year

Selectmonth (GetDate ());--Returns the current date month

Selectgetdate ();--Current system date

SQL Server Date Query tips