Re: Client side NLS_DATE_FORMAT, how do I set?

ALTER SESSION SET NLS_DATE_FORMAT='your date format' ;

This will alter current session to display the date in any format you desired. Hope this is what you're looking for. :) or :(

Biff Steel wrote in message <350aa879.160906571_at_news.alpha.net>...
>We have changed the NLS_DATE_FORMAT on our server and all works fine
>when we login from the server. When W95 or NT clients startup up
>windows tools, like SQLPLUS, the NLS_DATE_FORMAT reverts to the
>standard/default DD-MON-YY.
>
>I know I need to set something on the clients but not sure the best
>way to do this.
>
>Please help
>john moran jmoran_at_baraboo.com
Received on Sat Mar 21 1998 - 00:00:00 CET