topic Re: MSSQL server - Date column - Passing get current date issue from INSERT sql statement in Talend Studio

MSSQL server - Date column - Passing get current date issue from INSERT sql statement

gt0731 — Sat, 16 Nov 2024 00:29:33 GMT

Hi Everyone,

When i am trying to Execute INSERT DATA from tDBRow compoenent.

Here Trying to pass date column load_date( datetime not null) column as a current get date value.

Getting below errror

[ERROR]: star.xyz_updaterequest_insertaudt_0_1.xyz_UpdateRequest_InsertAudt - tDBRow_1 - Incorrect syntax near '12'.

[INFO ]: star.xyz_updaterequest_insertaudt_0_1.xyz_UpdateRequest_InsertAudt - tLogRow_2 - Content of row 2: 2370403|O|P|3680|2021-03-04 12:54:33

Request ID : 2370403

Any help on it would be much aprreciated ?

Anonymous — Fri, 05 Mar 2021 05:48:38 GMT

Hello,

Could you please show us your DB query in tDBRow component?

Best regards

Sabrina

gt0731 — Fri, 05 Mar 2021 10:30:36 GMT

SQL posted already

gt0731 — Fri, 05 Mar 2021 13:06:52 GMT

@xdshi getting this error when i am passing through globalMap

tDBRow_1 - Conversion failed when converting date and/or time from character string.

gt0731 — Fri, 05 Mar 2021 13:41:15 GMT

I am able to resolve the issue . Thanks

By using globalMap with cast and formatDate method works for me