formatting a date when some nulls exist - Mailing list pgsql-novice

From Eric Walstad
Subject formatting a date when some nulls exist
Date
Msg-id 3D73EE0E.2070800@walstads.net
Whole thread Raw
Responses Re: formatting a date when some nulls exist  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-novice
Hi All,
I'm trying to format a date type column, which contains some nulls.  I'm
getting an error:

ewtest=# select to_char(birthday, 'YYYY-MM-DD') from contacts;
ERROR:  Unable to convert date to tm

I'm assuming that the error is because of the null values.  If I
constrain the query to a record which I know has a valid date, it
returns the formatted date as I would expect:

ewtest=# select to_char(birthday, 'YYYY-MM-DD') from contacts where
fn='Rhys';
   to_char
------------
  1943-10-18
(1 row)

I suspect that I need to COALESCE or CASE my way out of this, but I
haven't been able to figure out how.  I'm hoping someone out there can
tell me how to return the formatted date or null or an empty string.

Thanks for any help!

Eric.


pgsql-novice by date:

Previous
From: "Warren Massengill"
Date:
Subject: contrib url
Next
From: Tom Lane
Date:
Subject: Re: formatting a date when some nulls exist