Can't Create Datetime datatype in BigQuery via Talend

[McJingles]

I can't create a Date Column in Datetime datatype in BigQuery.

If I create the job for that it automatically creates that column as a timestamp datatype.

If I load the sample date like this '2020-05-21T02:55:11.590' It saved in the datatype as timestamp an I can't retrieve that value as same as Date... It coming as a String like ' 165465767.590'

Please let me know the solution asap 

Thanks in Advance

[manodwhb]

@McJingles , what is the data type are you using in BigQuery? 

Talend supports the same data types than Big Query: https://cloud.google.com/bigquery/preparing-data-for-bigquery#datatypes

Have you tried to insert a tMap into your flow and change the datatypes from the output flow to what BigQuery only allows? After that you have to convert the types with the assignment expressions or you could use the tConvertType component.

[McJingles]

Thanks for your reply @manodwhb 

I am going to create the table using talent.. I give the datatype as Date and give a pattern (as same as source date pattern) for that in Talend.

I am creating a table on that way In BigQuery it creating the table and Date column datatype is timestamp...

I want the Date Datatype as Datetime in BigQuery...