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
2 years ago

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)