How to get difference of days/months/years (datediff) between two dates?

by

Simply subtract them:

SELECT ('2015-01-12'::date - '2015-01-01'::date) AS days;

The result:

 days
------
   11

More Related Contents:

  1. Get a list of dates between two dates using a function
  2. Get first day of week in SQL Server
  3. How do I exclude Weekend days in a SQL Server query?
  4. Get dates from a week number in T-SQL
  5. Date conversion and culture: Difference between DATE and DATETIME
  6. SQL Query to find the last day of the month
  7. How to: Create trigger for auto update modified date with SQL Server 2008
  8. Comparing dates stored as varchar
  9. How to migrate a PostgreSQL database into a SQLServer one?
  10. What is the PostgreSQL equivalent for ISNULL()
  11. migrate data from MS SQL to PostgreSQL?
  12. How do I generate a random number for each row in a T-SQL select?
  13. Combine multiple results in a subquery into a single comma-separated value
  14. Infinite loop CTE with OPTION (maxrecursion 0)
  15. Floor a date in SQL server
  16. LEN function not including trailing spaces in SQL Server
  17. How FOR XML PATH(”) works when concatenating rows
  18. SQL Server ORDER BY date and nulls last
  19. SSRS 2014 report deploy issue
  20. Best way to implement an audit trail in SQL Server?
  21. Set start value for column with autoincrement
  22. SqlDataAdapter.Fill method slow
  23. What is the Oracle equivalent of SQL Server’s IsNull() function?
  24. How to determine the field value which can not convert to (decimal, float,int) in SQL Server
  25. Making an Entity Framework Model span multiple databases
  26. SQL Server 2008 Row Insert and Update timestamps
  27. how to cast the hexadecimal to varchar(datetime)?
  28. Generate table relationship diagram from existing schema (SQL Server) [closed]
  29. Error converting data types when importing from Excel to SQL Server 2008
  30. CHECKSUM and CHECKSUM_AGG: What’s the algorithm?

Leave a Comment