Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
I am able to resolve the issue . Thanks
By using globalMap with cast and formatDate method works for me
Hello,
Could you please show us your DB query in tDBRow component?
Best regards
Sabrina
SQL posted already
@xdshi getting this error when i am passing through globalMap
tDBRow_1 - Conversion failed when converting date and/or time from character string.
I am able to resolve the issue . Thanks
By using globalMap with cast and formatDate method works for me