Date parameter

WoMaWil · Post by **WoMaWil** » Tue Jun 15, 2004 5:58 am

Hi Raquel,

Let us assume your Datefield in the oracle-Table SOMMER is START_DATUM, in DataStage you have to write in the where-Part an expression like:

to_char(SOMMER.START_DATUM,'YYYY-MM-DD')='2003-10-03'
or

to_char(SOMMER.START_DATUM,'YYYY-MM-DD')='#param_21#'

Good luck,

Wolfgang

rreyespe · Post by **rreyespe** » Wed Jun 16, 2004 2:16 am

Thank you, finally it worked

Raquel

ray.wurlod · Post by **ray.wurlod** » Wed Jun 16, 2004 2:25 am

Welcome aboard! :D Glad you've gotten a solution quickly. Recommend the site to your (DataStage) friends!