How to key in and display date with hours and minutes into Oracle SQL Developer

Question

I'm using Oracle SQL Developer. I'd like to key in dates with hours and minutes, but the GUI doesn't appear to allow that. While I'm at it, it would be nice to display all date fields as 'YYYY-MM-DD HH24:MI:SS' within the Oracle SQL Developer GUI as well.

Thanks!

Answer 1

After some more poking around I found the right preference setting.

Under "Tools -> Preference" there is a NLS node you can configure. The setting I changed was "Date Format", which I changed to 'YYYY-MM-DD HH24:MI:SS'.

Worked perfectly. My dates dispaly as I wanted, and the input mask on the GUI also allowed me to now edit time.

Cheers!

-Denis