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