Re: dates

From: Doug McNaught <doug(at)mcnaught(dot)org>
To: "peter" <peter(at)peter(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: dates
Date: 2002-11-08 15:59:44
Message-ID: m38z04vyq7.fsf@varsoon.wireboard.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"peter" <peter(at)peter(dot)com> writes:

> how do I convert a date from mm/dd/yyyy to dd/mm/yyyy

Dates are stored internally as a format-independent quantity. To
format a date, use the to_char() function. See the docs for
how to use to_char().

-Doug

In response to

  • dates at 2002-11-08 00:02:51 from peter

Browse pgsql-general by date

  From Date Subject
Next Message Doug McNaught 2002-11-08 16:03:55 Re: table growing
Previous Message Reinhard Max 2002-11-08 15:36:33 Re: [ANNOUNCE] PostgreSQL v7.3b5 Packaged for Testing ...