Uploaded image for project: 'Engineering'
  1. Engineering
  2. ENG-8743

VMC html results displays null TIMESTAMP values as 1970-01-01 00:00:00.000000

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Duplicate
    • Affects Version/s: V5.4
    • Fix Version/s: Future
    • Component/s: Core
    • Labels:
      None
    • Team Backlog:
      ECO team

      Description

      Test:

      In SQLCMD:
      create table foo (ts timestamp);
      insert into foo values (now);
      insert into foo values (null);
      select * from foo;

      TS
      ---------------------------
      2015-07-29 16:21:37.495000
      NULL

      In VMC:
      select * from foo;

      (CSV format)
      TS
      1438186897495000
      null

      (Monospace format)
      TS
      1438186897495000
      null

      (HTML format)
      TS
      2015-07-29 16:21:37.495000
      1970-01-01 00:00:00.000000

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              bballard Ben Ballard
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Zendesk Support