Re: dd/mm/yy - fixed default?

james wigley пишет в сообщении <3857a870_at_eeyore.callnetuk.com> ...
>Is it inevitable that and SQL scripts which queries a date field in an
>Oracle database will return with the format dd/mm/yy, unless the to_char(,)
>function is used - or is there a global default or setting that will
prevent
>me from having to update a load of old scripts?
>
>

try use ALTER SESSION SET NLS_DATE_FORMAT='DD.MM.YYYY' or other valid date format. Received on Wed Dec 15 1999 - 09:39:04 CST