Using Date format to fetch data from SQL in talend
this is how context variable can be used
"SELECT * FROM ACCOUNTS WHERE
TO_DATE(CREATEDATE, 'YYYY-MM-DD\"T\"HH24:MI:SS') <= " + context.LastRunTime + " AND
TO_DATE(LASTMODIFIEDDATE, 'YYYY-MM-DD\"T\"HH24:MI:SS') > " + context.LastRunTime
this is how context variable can be used
"SELECT * FROM ACCOUNTS WHERE
TO_DATE(CREATEDATE, 'YYYY-MM-DD\"T\"HH24:MI:SS') <= " + context.LastRunTime + " AND
TO_DATE(LASTMODIFIEDDATE, 'YYYY-MM-DD\"T\"HH24:MI:SS') > " + context.LastRunTime
No comments:
Post a Comment