Convert a datetime column to number of seconds
Create a new column (ALTER TABLE) then run an UPDATE on it

UPDATE
  MyTable
SET
  NewIntColumn = DATEDIFF(SECOND, '19000101', MyDateTimeColumn)


19000101 is the SQL Server epoch. You can use 19700101 for Unix epoch for example