Skip to content

Instantly share code, notes, and snippets.

@neurotech
Created February 21, 2013 23:23
Show Gist options
  • Save neurotech/5009388 to your computer and use it in GitHub Desktop.
Save neurotech/5009388 to your computer and use it in GitHub Desktop.
SELECT YEAR(current timestamp) + 1 AS "NEXT_TWENTY_YEARS" FROM SYSIBM.SYSDUMMY1
UNION
SELECT YEAR(current timestamp) + 2 AS "YEAR_PLUS_TWO" FROM SYSIBM.SYSDUMMY1
UNION
SELECT YEAR(current timestamp) + 3 AS "YEAR_PLUS_THREE" FROM SYSIBM.SYSDUMMY1
UNION
SELECT YEAR(current timestamp) + 4 AS "YEAR_PLUS_FOUR" FROM SYSIBM.SYSDUMMY1
UNION
SELECT YEAR(current timestamp) + 5 AS "YEAR_PLUS_FIVE" FROM SYSIBM.SYSDUMMY1
UNION
SELECT YEAR(current timestamp) + 6 AS "YEAR_PLUS_SIX" FROM SYSIBM.SYSDUMMY1
UNION
SELECT YEAR(current timestamp) + 7 AS "YEAR_PLUS_SEVEN" FROM SYSIBM.SYSDUMMY1
UNION
SELECT YEAR(current timestamp) + 8 AS "YEAR_PLUS_EIGHT" FROM SYSIBM.SYSDUMMY1
UNION
SELECT YEAR(current timestamp) + 9 AS "YEAR_PLUS_NINE" FROM SYSIBM.SYSDUMMY1
UNION
SELECT YEAR(current timestamp) + 10 AS "YEAR_PLUS_TEN" FROM SYSIBM.SYSDUMMY1
UNION
SELECT YEAR(current timestamp) + 11 AS "YEAR_PLUS_ELEVEN" FROM SYSIBM.SYSDUMMY1
UNION
SELECT YEAR(current timestamp) + 12 AS "YEAR_PLUS_TWELVE" FROM SYSIBM.SYSDUMMY1
UNION
SELECT YEAR(current timestamp) + 13 AS "YEAR_PLUS_THIRTEEN" FROM SYSIBM.SYSDUMMY1
UNION
SELECT YEAR(current timestamp) + 14 AS "YEAR_PLUS_FOURTEEN" FROM SYSIBM.SYSDUMMY1
UNION
SELECT YEAR(current timestamp) + 15 AS "YEAR_PLUS_FIFTEEN" FROM SYSIBM.SYSDUMMY1
UNION
SELECT YEAR(current timestamp) + 16 AS "YEAR_PLUS_SIXTEEN" FROM SYSIBM.SYSDUMMY1
UNION
SELECT YEAR(current timestamp) + 17 AS "YEAR_PLUS_SEVENTEEN" FROM SYSIBM.SYSDUMMY1
UNION
SELECT YEAR(current timestamp) + 18 AS "YEAR_PLUS_EIGHTEEN" FROM SYSIBM.SYSDUMMY1
UNION
SELECT YEAR(current timestamp) + 19 AS "YEAR_PLUS_NINETEEN" FROM SYSIBM.SYSDUMMY1
UNION
SELECT YEAR(current timestamp) + 20 AS "YEAR_PLUS_TWENTY" FROM SYSIBM.SYSDUMMY1
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment