topic Re: tDBInput Date column return null instead of date in Talend Studio

tDBInput Date column return null instead of date

Anonymous — Fri, 07 Jun 2019 06:55:28 GMT

Hello,

I'am testing migration from Oracle database data to Postgres with TOS 7.1.1.

Noticed that column with data type date returns null.

Pin it down to tDBInput SQL builder :

tDBInput schema :

(* tested without quotes "" too)

Set date pattern as suggested at

https://help.talend.com/reader/3zI67zZ9kaoTVCjNoXuEyw/YHc8JcQYJ7mWCehcQRTEIw :

The SQL query should return :

Re: tDBInput Date column return null instead of date

fdenis — Fri, 07 Jun 2019 08:53:20 GMT

in an other field, try to convert date to string into your sql query.
it may be helpfull.

Re: tDBInput Date column return null instead of date

Anonymous — Fri, 07 Jun 2019 10:42:04 GMT

There is no any convertion need, just pulling date as string.

If the destination DB has same date pattern, date might be pushed as string as well. In other case date might be converted in tMap.

Re: tDBInput Date column return null instead of date

Anonymous — Fri, 07 Jun 2019 15:10:46 GMT

Hi,

Could you please try to add the data type for this columns as Date with format "dd-MMM-yyyy" and ideally it should work fine.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Re: tDBInput Date column return null instead of date

Anonymous — Fri, 07 Jun 2019 15:13:49 GMT

so you saying that there is a mistake in documentaion with "d-MMM-yyyy" and it shoul be "dd-MMM-yyyy"?

Re: tDBInput Date column return null instead of date

Anonymous — Fri, 07 Jun 2019 15:19:17 GMT

Hi,

I have not personally tried the first format and I always prefer the format shared in my previous post. Did you get positive results when you tried in new format?

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Re: tDBInput Date column return null instead of date

Anonymous — Sat, 08 Jun 2019 05:09:23 GMT

Thank you all for quick response.

Actually, It was a mistake on my part. I updated date column to test this data type , but forgot to commit it. Therefore, got null as result.

After commit(in oracle) and guess schema (in tos) :

got desirable results :

However , if it posable , I would like to migrate date type columns without converting it to string on the way.

Re: tDBInput Date column return null instead of date

Anonymous — Sun, 09 Jun 2019 16:42:20 GMT

Hi,

If you scroll up all the comments associated with this post will be available for your reference.

Since the issue is resolved now, could you please mark the topic as resolved? This will help during reference by other Talend community members and its the best way to tell thanks to authors for contributing their time to your queries.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂