Database Schema

I was looking for the database schema for Team City.  I want to do some reporting on builds and tie the data into other systems.  Mostly what I need help on is how the dates are stored.  They are stored as a bigint so what is the algorithm to get them to a date time.  Is it ms from 0 or something like that?

1 comment

Hi Adam,

dates are stored as numbers of milliseconds since Jan 1, 1970, as it counted in Java. If you're developing on Java you can use just

   new Data(value)

where the value is one retrieved from the database.

Best wishes,


Please sign in to leave a comment.