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?
Please sign in to leave a 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,
Leonid