David Link <dlink@soundscan.com> writes:
> This frag returns a bogus date when column value is null:
> to_char(to_date (theatre_reldate, 'DDMMYYYY'), 'DD Mon YYYY')
Uh, what's bogus about it? I get a NULL result.
> So I'm looking for something of this sort:
> (case when not is null (t.theatre_reldate) then
It's spelled "something IS NULL" or "something IS NOT NULL".
regards, tom lane