(Mike Lewis) An application I support uses a BIGINT to store date and time data. Our installation is SQL Server 2005, so the lack of accuracy in the datetime data type is probably a driver behind this.
Read More - Register for Free Membership
SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help