Skip to content

Instantly share code, notes, and snippets.

@ateneva

ateneva/SQL_difference_between_timeperiods_functions_vertica.sql

Last active January 2, 2018 18:12
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save ateneva/286d30a9a9abc440d88aab5bbd7a46aa to your computer and use it in GitHub Desktop.
Save ateneva/286d30a9a9abc440d88aab5bbd7a46aa to your computer and use it in GitHub Desktop.
Download ZIP
Find the difference between two dates
Raw
SQL_difference_between_timeperiods_functions_vertica.sql
------------------------------------------Vertica----------------------------------------------------------------------------------------
select
age_in_months(Now(), '1988-06-21'), --calculates completed period without current month
age_in_years(Now(), '1988-06-21'), --calculates completed period without current month
datediff('month', '1988-06-21', Now()) as MonthsBetweenDates, --includes current month in calculation
datediff('year', '1988-06-21', Now()) as YearsBetweenDates, --includes current month in calculation
months_between (Now(),'2017-01-01') -- calculates months between two dates as a float
-----------------------------------------MySQL------------------------------------------------------------------------------------------------
select
period_diff(201712, 201707) as Past, --months between now and a past date
period_diff(201806, 201712) as Future --months between now and a future date
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment