Skip to content

Instantly share code, notes, and snippets.

@giammin

giammin/birthday.sql

Created May 31, 2016 09:52
Show Gist options
  • Save giammin/46f6b05dfd28db387e369706914c54f2 to your computer and use it in GitHub Desktop.
Save giammin/46f6b05dfd28db387e369706914c54f2 to your computer and use it in GitHub Desktop.
Download ZIP
calculate day before birthday
Raw
birthday.sql
DECLARE @birthday datetime;
set @birthday='1916-02-29T11:35:42.710';
DECLARE @today datetime;
set @today='2015-03-01T11:35:42.710';
declare @calc datetime;
set @calc=DAteadd(day,-1,DATEADD(year,year(@today)-YEAR(@birthday),@birthday));
select @today as today,@birthday as birthday, @calc as calc, iif(CONVERT(date, @today)=CONVERT(date, @calc),1,0)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment