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
mrdwprice's avatar
mrdwprice
Contributor

What data type does Table1.Time have in your database?
is it DATETIME?

arasi_m's avatar
arasi_m
Occasional Contributor
2 years ago

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)