how to query date in sql server

Solutions on MaxInterview for how to query date in sql server by the best coders in the world