Forum: Building VoltDB Applications

Post: Null values for TIMESTAMP

Null values for TIMESTAMP
loorely
Jul 28, 2015
I try to store null values for a timestamp column in my db. But it always store date 1970-01-01 00:00:00.000000.
For example i did:

update table_name set end_day = null where dia_facturacion = 16.

Then i get:










end_day dia_facturacion
1970-01-01 00:00:00.000000 16
bballard
Jul 29, 2015
Hi,

There seems to be an issue in the HTML display of query results in the VMC interface. The internal value is in fact null. If you run the same query in SQLCMD, you should see NULL.

I logged a ticket for this: https://issues.voltdb.com/browse/ENG-8743

Thanks,
Ben