Mega Code Archive

 

Categories / MSSQL / Date Timezone

 

DATEDIFF(ss, @MyBirthDate, GETDATE())

1> DECLARE @MyBirthDate DateTime 2> SET @MyBirthDate = '3-24-1967' 3> SELECT DATEDIFF(ss, @MyBirthDate, GETDATE()) 4> GO -----------  1248289384 (1 rows affected) 1>