date functions - Mailing list pgsql-general

From Johnson, Shaunn
Subject date functions
Date
Msg-id 73309C2FDD95D11192E60008C7B1D5BB0452DE20@snt452.corp.bcbsm.com
Whole thread Raw
Responses Re: date functions  (Darren Ferguson <darren@crystalballinc.com>)
Re: date functions  (Jason Earl <jason.earl@simplot.com>)
List 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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: timestamp weirdness
Next
From: "Johnson, Shaunn"
Date:
Subject: SQL logic