How to get DATE in server locale format

From: "Andrus" <kobruleht2(at)hot(dot)ee>
To: <pgsql-general(at)postgresql(dot)org>
Subject: How to get DATE in server locale format
Date: 2010-01-10 21:57:38
Message-ID: 48A2CF6A4DC548F19EE641A66DFEEC34@andrusnotebook
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Server lc_times contains non-US locale.

SELECT CURRENT_DATE::TEXT

still returns date in format YYYY-MM-DD

How to get date in server locale format ?

Andrus.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Yan Cheng Cheok 2010-01-11 01:49:38 Re: Return Single Row Result After Inserting (Stored Procedure)
Previous Message Peter Eisentraut 2010-01-10 17:29:10 Re: 8.4.1 & 8.4.2 require map=... for ident in the pg_hba.conf file, will this be the new way?