Re: Store dates in database in different format

From: Bill Moran <wmoran(at)potentialtech(dot)com>
To: RPK <rpk(dot)general(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Store dates in database in different format
Date: 2007-04-27 18:16:38
Message-ID: 20070427141638.8f01d266.wmoran@potentialtech.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

In response to RPK <rpk(dot)general(at)gmail(dot)com>:
>
> I am using pgsql 8.2.3 on windows XP. I noticed that dates are store in
> 'Date' columns of a table in "yyyy-mm-dd" format whereas I want to store it
> in "dd-MMM-yyyy" format. Can I change this?

They're not stored in that format, they're just displaying in that format.

Here's a good place to start reading:
http://www.postgresql.org/docs/8.2/static/datatype-datetime.html#DATATYPE-DATETIME-OUTPUT

--
Bill Moran
http://www.potentialtech.com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jeff Davis 2007-04-27 18:19:22 Re: Store dates in database in different format
Previous Message Bill Moran 2007-04-27 18:11:27 Re: Feature Request --- was: PostgreSQL Performance Tuning