SQL DEV doesn't show full DATE

Question

I use Oracle SQL Developer and Query Result doesn't return me full date. Also the same format (yyyy/mm/dd) in table -> data. How to fix this? I didnt find any option which would help.

Answer 1

It's just formatting issue. Goto "Tools->Preferences->Database->NLS" , set Date Format to something like "YYYY-MM-DD hh24:mi:ss" .

or you can run ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD hh24:mi:ss'

Answer 2

That's because the default behaviour of SQL Developer is to ony show the date part. Try forcing the output to be displayed as a datetime string this way

select  id, id_player, id_map, x, y, to_char(time, 'yyyy/mm/dd hh24:mi:ss')
from LOGI