Alright, I figured out where the formatting is incorrect. I shouldn't have had
the "published_date=" in there.
Now it's giving me, "ORA-01861: literal does not match format" which is much
closer.
And I still have the question on whether I should use concatenation to create
the string once I replace my test string.
> CASE WHEN published_month is not null THEN
>published_date = to_date('2003/07/09') ELSE to_date('2003/07/09') END
>as published_date
and thanks for any assistance.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
ColdFusion MX7 by Adobe®
Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7.
Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:276768
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
