date functions

From: "Johnson, Shaunn" <SJohnson6(at)bcbsm(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: date functions
Date: 2002-02-01 13:53:40
Message-ID: 73309C2FDD95D11192E60008C7B1D5BB0452DE20@snt452.corp.bcbsm.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Howdy:

Silly question. I want to display the date from
my table in other formats. Is this possible?

For example, I have this:

[example]

date
------------
2000-01-07

[/example]

And I want this:

[example]

date
------------
20000107

[/example]

And maybe this:

[example]

date
------------
01/07/2001

[/example]

Any suggestions? Thanks!

-X

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Holger Krug 2002-02-01 14:00:40 Re: trigger-procedure without plpgsql
Previous Message Mike Mascari 2002-02-01 13:27:39 Re: ORDER BY in \dt+ ?