Re: Date Formatting for dd/mm/yyyy

From: Artacus <artacus(at)comcast(dot)net>
To: PostgreSQL <pgsql-general(at)postgresql(dot)org>
Subject: Re: Date Formatting for dd/mm/yyyy
Date: 2008-07-03 15:04:24
Message-ID: 486CEA78.9050005@comcast.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

J Ottery wrote:
> Hi all.
> I am using Postgres 8.3 with Windows XP Pro.
> System date format is dd/MM/yyyy
>
> Having problems when I writing records to a database with a single
> 'date' type field.

I may be confused here. You say writing was your problem but it sounds
like the problem is when you read the records out.

The way dates are displayed is dependent on (and configured in) the
client not on the server. So if you have a specific format you want your
dates displayed then you need to convert them to a string in your query.

Artacus

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Valter Douglas Lisbôa Jr. 2008-07-03 15:05:15 High inserting by syslog
Previous Message Csaba Nagy 2008-07-03 15:03:37 Re: Switching between terminals