https://community.hpe.com/t5/server-management-systems/sim-database-date-time-column-conversion/m-p/4505169#M39027 This is pretty common in SQL databases and represents time elapsed since 1/1/1970. Google for SQL BIGINT DATE and you'll find a number of algorithms to use. Wed, 30 Sep 2009 03:17:13 GMT David Claypool 2009-09-30T03:17:13Z https://community.hpe.com/t5/server-management-systems/sim-database-date-time-column-conversion/m-p/4505168#M39026 I'm trying to run custom SQL scripts on the Insight database. The date-time columns are not written as a readable format. Instead, everything is a random number. <BR /><BR />These columns are the bigint datatype which doesn't allow conversion.<BR /><BR />When running reports in SIM, there are obviously some program files somewhere that are converting the data to a recognized date format.<BR /><BR />Has anyone been able to write a SQL query against this database and successfully convert the date/time? Tue, 29 Sep 2009 19:16:46 GMT https://community.hpe.com/t5/server-management-systems/sim-database-date-time-column-conversion/m-p/4505168#M39026 SmooshedFace76 2009-09-29T19:16:46Z https://community.hpe.com/t5/server-management-systems/sim-database-date-time-column-conversion/m-p/4505169#M39027 This is pretty common in SQL databases and represents time elapsed since 1/1/1970. Google for SQL BIGINT DATE and you'll find a number of algorithms to use. Wed, 30 Sep 2009 03:17:13 GMT https://community.hpe.com/t5/server-management-systems/sim-database-date-time-column-conversion/m-p/4505169#M39027 David Claypool 2009-09-30T03:17:13Z