date comparision

prasanna2100 · Post by **prasanna2100** » Fri Apr 28, 2006 8:22 am

guys i need to extract in the input stage, a date field,decimal field,and a longVarchar field.with a where condition as date field = (a prompt of string datatype for system date)

kcbland · Post by **kcbland** » Fri Apr 28, 2006 8:27 am

What's your input stage? If it's Oracle, then add a WHERE clause to the SQL to include a job parameter date value.

prasanna2100 · Post by **prasanna2100** » Fri Apr 28, 2006 8:45 am

yes iam having a oracle i/p stage and where clause shd be comparing a date .how should i specify my job parameter (which formate) do i need to convert both the fields to some format?

ray.wurlod · Post by **ray.wurlod** » Fri Apr 28, 2006 3:58 pm

Any format you like - include a TO_DATE() function as part of your WHERE clause, with an appropriate date picture for your chosen format.

chulett · Post by **chulett** » Fri Apr 28, 2006 4:39 pm

For 'system date' use sysdate - no parameter required.

Sreenivasulu · Post by **Sreenivasulu** » Fri Apr 28, 2006 11:05 pm

HI..

Please search the forum before posting the question. This has been answered many times before

Regards
Sreenivasulu

prasanna2100 wrote:guys i need to extract in the input stage, a date field,decimal field,and a longVarchar field.with a where condition as date field = (a prompt of string datatype for system date)

DSXchange

date comparision

date comparision

Re: date comparision