Skip to content

Instantly share code, notes, and snippets.

@inog

inog/selectcreated_plus_6_month.sql

Last active December 7, 2017 13:47
Show Gist options
  • Save inog/f492bde950e68b4dd0d00b6d2665de33 to your computer and use it in GitHub Desktop.
Save inog/f492bde950e68b4dd0d00b6d2665de33 to your computer and use it in GitHub Desktop.
Download ZIP
select year and month from an datefield added 6 month
Raw
selectcreated_plus_6_month.sql
SELECT kakan1,kakan2, kavjah, kavmon, kaerft, add_months(kaerft,6) addMonth,
YEAR(kaerft) created_Y, Month(kaerft) created_M ,
YEAR(add_months(kaerft,6)) newYear, Month(add_months(kaerft,6)) newMonth
FROM verkauf.kalkN
order by kaerft DESC;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment