Date formats

[jacew]

Hi There,
I would like to know how pl/sql formats dates that are returned.

There is an option in the tools menu which allows the user to specify the format. I'm sure it doesn't use do it by alter session set nls_date_format = 'dd-mm-yyyy'.

So how does it do it?

Thanks

Jason

 

[Marco Kalter]

PL/SQL Developer uses the standard windows functions to format/interpret a date value on the client side. The NLS_DATE_FORMAT does not affect this, unless you specify that the format should follow the Oracle format.