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

[gt0731]

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]

Hello,

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

Best regards

Sabrina

[gt0731]

SQL posted already

[gt0731]

@xdshi getting this error when i am passing through globalMap

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

[gt0731 · Accepted solution]

I am able to resolve the issue . Thanks

By using globalMap with cast and formatDate method works for me