SQLHacks for Microsoft SQL Server

Home page

Administration

Dates & Times

Data Manipulation

FAQs

Optimization

Summaries


Site Map



About us

  • About us
  • Copyrights
  • Credits
  • Disclaimers
  • Guaranties
  • Privacy
  • Support policies

Feedback

Dates

MS SQL Server date & time

Dates & Times

  • Finding overlapping dates ranges with MSSQL
  • How to calculate somebody's age with MSSQL?
  • How to convert strings to dates and times to strings with MS SQL Server
  • How to deal with different local timezones with MSSQL
  • How to display dates in easy to read format with MSSQL
  • How to display dates in easy to read format with MSSQL
  • How to drop the time portion of the DateTime in MS SQL Server
  • How to enter ANSI dates with MSSQL
  • How to extract portions of dates with MSSQL
  • How to find out if this is a leap year with MSSQL
  • How to get the date portions from datetime with MS SQL Server
  • How to get the weekdays date range with MSSQL
  • How to group by month with MS SQL Server
  • How to group by week with MSSQL
  • How to keep dates in UTC with MSSQL
  • How to search and group by month & year with MSSQL
  • How to search and group by year with MSSQL
  • How to search for dates with SQL Server
  • How to select sales during banking hours with MSSQL
  • Last day of the month with MSSQL
  • MS SQL Server date calculations
  • Problem with date selections in MS SQL Server
  • Select for the week with MSSQL
  • Timestamps and MS SQL Server
  • What the difference between timestamp and current_timestamp with MS SQL Server
  • Wrong results with Datediff in MS SQL Server?

All contents in SQLHacks.com are the property of db Networks Ltd and it's affiliates. All other trademarks not owned by db Networks Ltd or its affiliates that appear on the SQLHacks.com site are the property of their respective owners, especially: Windows®, MS SQL®, SQL Server® which are the property of Microsoft Corp. DB2® which is the property of IBM Systems. Oracle database® which is the property of Oracle Corp.