Announcement

Collapse
No announcement yet.

Null values for TIMESTAMP

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Null values for TIMESTAMP

    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

  • #2
    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

    Comment

    Working...
    X