Re: Casting timestamp with time zone to varchar automatically - Mailing list pgsql-general

From Michael Glaesemann
Subject Re: Casting timestamp with time zone to varchar automatically
Date
Msg-id 66A83ED2-E51A-11D8-8966-000A95C88220@myrealbox.com
Whole thread Raw
In response to Casting timestamp with time zone to varchar automatically  ("Jim C. Nasby" <decibel@decibel.org>)
Responses Re: Casting timestamp with time zone to varchar automatically  ("Jim C. Nasby" <decibel@decibel.org>)
List pgsql-general
On Aug 3, 2004, at 3:12 PM, Jim C. Nasby wrote:

> Is there any reason why there isn't a predefined cast to go from a
> timestamp to a varchar? Is there a reason not to add one?

to_char should do what you need. People often need a specific form of
timestamp if they need it to be a text value (rather than a native
timestamp data type). to_char provides lots of flexibility


Michael Glaesemann
grzm myrealbox com


pgsql-general by date:

Previous
From: Markus Bertheau
Date:
Subject: Re: [ANNOUNCE] == PostgreSQL Weekly News - August 1st 2004 ==
Next
From: "Gellert, Andre"
Date:
Subject: Are Packages for PostgreSQL 7.4.x for Solaris 9 64bit available ?