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 3D73EB12.4090501@ericwalstad.com
Whole thread Raw
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: George Donnahoo
Date:
Subject: RAISE statements
Next
From: Mark Fletcher
Date:
Subject: Re: Dealing with unique IP adresses and ranges