I'm trying to convert the following dates into sql from sas, both are coming up incorrect. Any suggestions?
CASE WHEN date_of_birth <0 THEN DATEADD(ss,21914,CAST(ABS(date_of_birth) AS DATETIME))
ELSE DATEADD(ss,1893369600,CAST([date_of_birth] AS DATETIME) ) END as BirthDate
-58438 2059-12-31 06:05:14.000
2647911 9209-09-25 00:00:00.000