Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
gt0731
Contributor III
Contributor III

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

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 ?

Labels (3)
1 Solution

Accepted Solutions
gt0731
Contributor III
Contributor III
Author

I am able to resolve the issue . Thanks

By using globalMap with cast and formatDate method works for me

View solution in original post

4 Replies
Anonymous
Not applicable

Hello,

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

Best regards

Sabrina

gt0731
Contributor III
Contributor III
Author

SQL posted already

 

gt0731
Contributor III
Contributor III
Author

@xdshi getting this error when i am passing through globalMap

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

gt0731
Contributor III
Contributor III
Author

I am able to resolve the issue . Thanks

By using globalMap with cast and formatDate method works for me