Difference between two date timestamps month wise and year wise
suggest changeMonthwise difference between two dates(timestamp)
select
(
(DATE_PART('year', AgeonDate) - DATE_PART('year', tmpdate)) * 12
+
(DATE_PART('month', AgeonDate) - DATE_PART('month', tmpdate))
)
from dbo."Table1"
Yearwise difference between two dates(timestamp)
select (DATE_PART('year', AgeonDate) - DATE_PART('year', tmpdate)) from dbo."Table1"
Found a mistake? Have a question or improvement idea?
Let me know.
Table Of Contents