This is absolutely the wrong thing to do. Dates should not be stored as integers.
What are the business rules stating that you should convert the column from a DATETIME datatype to BIGINT? In other words, why do they want to do this?
--Jeff Moden
Change is inevitable... Change for the better is not.