Forum Discussion

ameett's avatar
ameett
Contributor
8 years ago

JDBC request Test step Response has incorrect dates

Hello All I am saving some information in the database and then querying the database to verify if correct information is saved. I am using -JDBC request-  test step for querying the database. Aft...
ameett's avatar
ameett
Contributor

Thanks for your prompt reply. :)

 

Yes, the data machine has correct time.

 

The JDBC request test step directly interacts with the sqlserevr. There is no any other application in between

 

-Ameett

nmrao's avatar
nmrao
Champion Level 3
8 years ago
In that case, how it is coming 2 day before's date? or difference?
  • ameett's avatar
    ameett
    Contributor
    8 years ago

    I will check once again if any application is in between.

     

    But if we assume that there is an application in between what needs to be check?

     

    There is one another operation - Get customer - if we provide the custid to it, it gives the correct date in the response.

     

    Thanks

    Ameett

     

     

  • sachintha's avatar
    sachintha
    New Contributor
    6 years ago

    Hi nmrao 

     

    I had that u mentioned issue,

     

    My SoapUI JDBC request gives me a wrong date (2days backdate), but i run the same SQL query in my SQL management studio it gives the correct result.

     

    Ex:- SQL management result  2018-05-10

            SoapUI JDBC result        2018 - 05 - 08

     

    can you help me?