difference between max(datecolumn) and max(to_date(datecolumn),'dd-mm-rrrr')

[PSoni]

we are noticing that by setting the session

nls_date_format

we are getting correct result

the old nls_date_format was 'DD-MON-YY'

new session is 'DD-MM-YYYY'


I want to know if procedure/fuction will be affected by the session's parameter .


soni