Forum Discussion

arasi_m's avatar
arasi_m
Occasional Contributor
2 years ago

How to build SQL query using strings whose value should be retrieved from TestCase property

Suppose i have the following properties defined in the Test Case Properties FromTime = 2023-11-15 23:00:00 ToTime = 2023-11-16 23:00:00   I want to replace the time given in the below query...
Configuration
Data-Driven Testing
REST
Scripting
arasi_m's avatar
arasi_m
Occasional Contributor

Hello,

 

In the database it is defined like this

 

Time(datetime2(0),not null)

mrdwprice's avatar
mrdwprice
Contributor
2 years ago

Try using the CAST or CONVERT function

SELECT * FROM Table1 WHERE TagId = 4314 AND Time > CAST('${#TestCase#FromTime}' AS datetime2)