Date Timezone MSSQL

  1. Home
  2. MSSQL
  3. Date Timezone
  4. 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>