Re: How to get DATE in server locale format

> You might be able to get what you want with the to_char() function,
> if setting datestyle doesn't do the trick for you.

setting datestyle changes style for whole sql statement.

How to get this in a single conversion in sql statement so that other
expressions in same sql statement are not affected.

to_char() requires hard-coded format.
Different servers have different locales so that format is not know at
application design time.

How to get localized date for single conversion inside SELECT statement so
that it works in different server lc_time settings ?

Andrus.