This content has been marked as final.
Show 1 reply
-
1. Re: Regarding type convertion
shawkins Nov 17, 2010 1:02 PM (in response to jalen)Hi Jalen,
Use "cast(null as date) as START_DATE". While null is implicitly convertable, the desiger does not currently automatically change the types of the select clause to match the view. You can use the reconsiler dialog to have designer add the conversion functions for you.
Steve