18 Mar 2007
Hi,
COALESCE(Field name , 'Any string or Valid Date')
Hope this helps
Cheers!!
18 Mar 2007
But it is not excepting that,it is throughing an error that IF/THEN datatype are not matching.
I hav tried with all format.
kamal
19 Mar 2007
Try using current_date
19 Mar 2007
Its wrking with current date , But i wanted to gave exact date there.
19 Mar 2007
Hi Kamal,
date: COALESCE(date_col, date '2007-03-19')
string: COALESCE(trim(date_col), 'blabla')
Dieter
12 Oct 2009
That works like a charm. Thanks!
You must sign in to leave a comment.
I have a join of two tables ,where i need to convert null date values to some valid date or a string.
How this can done with the COALESCE ?