What I meant with 'I'm having issues with the NLS settings not being used' is that I set the format in preferences and still when I select a date, timestamp it shows just the date without time.
The updating of the session is just a workaround to get the results that I want, temporary though...