Talend community forum / Select NOW() problem

Kiva · 2009-05-07 12:06:12

Hi guy,

I have a problem with a job. I need to know the yesterday date to find a file for my job.
I would like use functions date of mysql like DATE_SUB but it doesn't work.

I use a tMysqlInput or a tMysqlRow but I have an error when I use the function NOW(). Indeed, talend use NOW() as a variable name and it doesn't work (logical)

How can I use these functions to create variable(s?) and use them in a tJava?

I post two screen shot for a better explaination.

Thanks for your help.

Uploaded Images

tnewman · 2009-05-08 20:40:54

Hi,

The syntax for the NOW() stmt is :-

SELECT NOW() FROM table_name

I guess you could use any table in your db.

As for assigning to context variable, try TjavaRow like :-

if (row1.datetime !=null) {
context.var_name=row1.datetime;
}

HTH

bluesin · 2009-05-08 23:10:04

You use the table name of dual when you want to select on literals or functions without accessing an actual table. "dual" is a dummy table operand, not sure how it'll work in Talend though...

Select now() from dual;

shong · 2009-05-11 05:31:06

Hello
As tnewman and bluesin said.
"select now() from dual"
Please see my screenshot.

Best regards

shong

Uploaded Images

Kiva · 2009-05-11 09:50:58

Hi guy,

Thanks for your answer.

To find the date, I used a tJava with Calendar.add method and this solution works.

Announcement

Unanswered posts

#1 2009-05-07 12:06:12

Select NOW() problem

#2 2009-05-08 20:40:54

Re: Select NOW() problem

#3 2009-05-08 23:10:04

Re: Select NOW() problem

#4 2009-05-11 05:31:06

Re: Select NOW() problem

#5 2009-05-11 09:50:58

Re: Select NOW() problem

Board footer