oracle - sql developer time format -


i have add column db oracle sql developer. column needs format hh:mi:ss, when set column timestamp, convert me column : dd-mm-yy hh:mi:ss, if change nls settings.

you can change preferences follows:

go tools > preferences.

in preferences dialog, select database > nls left panel.

from list of nls parameters, enter hh:mi:ss timestamp format field.

save , close dialog.


Comments