Menu

#1401 Dates older than 1940 display as null.

SQuirreL
closed-duplicate
nobody
high
2019-08-19
2019-08-12
Beth Auton
No

Dates older than 1940-01-01 show as <null>. Is there a fix or setting to resolve this?
There's also an old ticket that is similar - reporting that dates 2040/forward also only show as <null></null></null>

Discussion

  • Gerd Wagner

    Gerd Wagner - 2019-08-18
    • status: open --> closed-duplicate
     
  • Gerd Wagner

    Gerd Wagner - 2019-08-18

    This bug is not exactly a duplicate of 921 (https://sourceforge.net/p/squirrel-sql/bugs/921/) but very close. That's why this bug is closed as duplicate and discussion will be carried on in 921.

     
  • Claus

    Claus - 2019-08-19

    Hi,
    this may be your solution:
    https://www-01.ibm.com/support/docview.wss?uid=nas8N1017268
    "jdbc:as400://RCHASSLH;date format=iso;time format=iso;"
    Greetings
    Claus

     

Log in to post a comment.

MongoDB Logo MongoDB