Forum Stats

  • 3,771,083 Users
  • 2,253,218 Discussions
  • 7,875,743 Comments

Discussions

View TIMESTAMP(9) WITH TIME ZONE aka oracle.sql.TIMESTAMPTZ

John Or
John Or Member Posts: 2 Green Ribbon
edited Nov 9, 2021 9:55PM in Java Programming

From Oracle Sql Developer the Sql

SELECT USER_ID, LAST_LOGIN from DBA_USERS where LAST_LOGIN not like '%null%' ;

nicely produces

USER_ID LAST_LOGIN

9 27-OCT-21 12.57.46.000000000 PM AMERICA/NEW_YORK

86 21-SEP-21 04.25.35.000000000 PM AMERICA/NEW_YORK

111 09-NOV-21 09.40.12.000000000 AM AMERICA/NEW_YORK

109 09-NOV-21 03.33.51.000000000 PM AMERICA/NEW_YORK

Where as the same Sql run from java runs Ok. However the LAST_LOGIN column provides nothing that looks like a date and time with tome zone

Please Advise.

Thanks

John Or