Forum: Building VoltDB Applications

Post: Timestamps, Dates and timezone interactions

Timestamps, Dates and timezone interactions
Apr 21, 2010
We run VoltDB nodes in GMT. This affects creation of Date objects in stored procedures. Date objects created in stored procedures are by default created relative to GMT. You can use the Java calendar functionality to explicitly create a Date for a different timezone inside a stored procedure.

The TIMESTAMP schema type is agnostic to timezones. It stores microseconds since the standard epoch and does not store any implicit timezone. Timestamps created externally and passed to VoltDB procedures are not automatically normalized to GMT (or any other timezone) by VoltDB.