Home Forums SQL Server 2012 SQL Server 2012 - T-SQL Convert Bigint time to datetime RE: Convert Bigint time to datetime
gbritton1
SSCertifiable
Points: 6522
More actions
April 17, 2014 at 12:28 pm
#1706894
Sorry, you're quite right! That should be:
declare @maxminutes bigint = datediff(day, '0001-01-01', '9999-12-31')*cast(24*60 as bigint)
select @maxminutes
which yields: 5258963520