Home > mailing lists

How to get DATE in server locale format - Mailing list pgsql-general

From	Andrus
Subject	How to get DATE in server locale format
Date	January 11, 2010 07:21:57
Msg-id	48A2CF6A4DC548F19EE641A66DFEEC34@andrusnotebook Whole thread Raw
Responses	Re: How to get DATE in server locale format (Leif Biberg Kristensen <leif@solumslekt.org>) Re: How to get DATE in server locale format (Tom Lane <tgl@sss.pgh.pa.us>)
List	pgsql-general

Tree view

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.

pgsql-general by date:

From: Craig Ringer
Date: 11 January 2010, 07:20:43
Subject: Re: Get Unix timestamp from SQL timestamp through libpq

From: Yan Cheng Cheok
Date: 11 January 2010, 07:41:45
Subject: Custom Field for a table row returned from stored procedure

How to get DATE in server locale format - Mailing list pgsql-general

Previous

Next