topic Re: can anyone help me with this query? in Talend Studio

can anyone help me with this query?

Anonymous — Tue, 23 May 2017 04:57:32 GMT

after running job it gives error like unparseble date

context.Query_string="select date_key,inc_date from date_dim where inc_date >'" +TalendDate.formatDate("yyyy-MM-dd",TalendDate.parseDate("dd-MM-yyyy",context.Last_Loaded_Date))+"'and inc_date < now()";

Re: can anyone help me with this query?

TRF — Wed, 06 Sep 2017 20:03:59 GMT

As your date value is enclosed between '' you probably need to use a SQL conversion fonction such as to_date.
Did you try this:
context.Query_string="select date_key,inc_date from date_dim where inc_date > to_date('" +TalendDate.formatDate("yyyy-MM-dd",TalendDate.parseDate("dd-MM-yyyy",context.Last_Loaded_Date))+"') and inc_date < now()"

Re: can anyone help me with this query?

vapukov — Sun, 10 Sep 2017 02:07:32 GMT

context.Query_string="select date_key,inc_date from date_dim where inc_date >'" +TalendDate.formatDate("yyyy-MM-dd",TalendDate.parseDate("dd-MM-yyyy",context.Last_Loaded_Date))+"'and inc_date < now()";

missed space

context.Query_string="select date_key,inc_date from date_dim where inc_date >'" +TalendDate.formatDate("yyyy-MM-dd",TalendDate.parseDate("dd-MM-yyyy",context.Last_Loaded_Date))+"'SPACE_MUST_BE_THERE and inc_date < now()";

Re: can anyone help me with this query?

Anonymous — Tue, 12 Sep 2017 16:03:03 GMT

i will try it.