Skip to content

Instantly share code, notes, and snippets.

@jz3lada

jz3lada/DATEADD

Last active August 29, 2015 14:01
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 jz3lada/cad973bfd7e3e19aafb4 to your computer and use it in GitHub Desktop.
Save jz3lada/cad973bfd7e3e19aafb4 to your computer and use it in GitHub Desktop.
Download ZIP
Quitar/Agregar a un fecha una cantidad de días/meses/años especifica
Raw
DATEADD
/*
for more info:
http://msdn.microsoft.com/es-es/library/ms186819.aspx
*/
DECLARE @Date DATETIME
SET @Date=Getdate()
DATEADD(DAY,-1,@Date)
DATEADD(YEAR,2,@Date)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment