topic Re: Return UTC Date object in Talend Studio

Return UTC Date object

RNikolova1624628702 — Sat, 16 Nov 2024 00:00:50 GMT

Hello guys! I am struggling with date conversion in the Talend Open Studio, and I would need some help. I have a column of type Date, so I need to return from the Expression Builder Date object. But I need my time to be formatted like this "yyyy-MM-dd HH:mm:ss" and to be in UTC. Whatever I have tried the time is not showing correctly. If you see the screenshot below you will see that the time is shown as EEST time, not UTC. 😞 It is important to return Date, NOT String. Any help would be highly appreciated! Thank you in advance!

Re: Return UTC Date object

Anonymous — Mon, 28 Jun 2021 07:40:53 GMT

Hello,

Without using Test! in tMap expression builder, could you please drag a tlogrow component after tMap to print your date on console to see if it displays well.

Best regards

Sabrina

Re: Return UTC Date object

RNikolova1624628702 — Mon, 28 Jun 2021 12:17:31 GMT

Hey Sabrina!

Thank you for the response! I didn't know about the tlogrow component, thank you for informing me about it. I tried it, and here's what I get in the console: 2021-06-28 12:14:01

Re: Return UTC Date object

gjeremy1617088143 — Mon, 28 Jun 2021 14:19:56 GMT

Hi, if you whant currentdate in Utc :

TalendDate.parseDateInUTC("yyyy-MM-dd HH:mm:ss",TalendDate.formatDate("yyyy-MM-dd HH:mm:ss",TalendDate.getCurrentDate()))

in the metadate schema you set the pattern to "yyyy-MM-dd HH:mm:ss"

Send me Love and Kudos

Re: Return UTC Date object

Anonymous — Tue, 29 Jun 2021 03:38:33 GMT

Hello,

tLogrow is usually used to display data or results in the Run console to monitor data processed.

Here is the related component reference about: TalendHelpCenter: tLogrow

Best regards

Sabrina