Output doesn't match date formatting

JSanda15 — Sat, 16 Nov 2024 00:48:15 GMT

I am trying to run a query and am encountering error when converting the date.

Variable name = startDate

type = Date

value = 2020-01-03 00:00:00

function = TalendDate.formatDate("yyyy-MM-dd",context.startDate)

expected output = 2020-01-03

Actual output = 2020 - 1 - 3

If I don't use formatDate my output is equally useless = Fri Jan 3 2020 etc.

I am just trying to do a basic query : SELECT * FROM {table] WHERE {field} >

TalendDate.formatDate("yyyy-MM-dd",context.startDate)

How do I get the expected output?

Re: Output doesn't match date formatting

jilanisyed — Mon, 25 Jan 2021 16:28:16 GMT

Hi, Please check the date type Pattern in the input component. Tranformation:

TalendDate.formatDate("yyyy-MM-dd",row1.startDate )

output: