JDBC request Test step Response has incorrect dates

Question

Hello AllI am saving some information in the database and then querying the database to verify if correct information is saved.I am using -JDBC request- &nbsp;test step&nbsp;for querying the database.After executing JDBC request test step a response is returned which I am verifying with XQuery assertion&nbsp;The problem is that in the above response that I get, has incorrect dates though dates in database are correct one.Also there is a pattern in this,&nbsp;the date returned in response is less than 2 days than the date in the database.for e.g. date in Database = 2017-06-01&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;date in response = 2017-05-30date format is - yyyy-mm-dd&nbsp;May I request you to please help me regarding this?If possible could anyone please reply fast, as it is bit urgent&nbsp;Thanks-Ameett

nmrao · Answer

Have you checked if the data machine has correct data and time? And if there is any application storing data into database, then are they both in sync(date and time)?

ameett · Answer

Thanks for your prompt reply. :)&nbsp;Yes, the data machine has correct time.&nbsp;The JDBC request test step directly interacts with the sqlserevr. There is no any other application in between&nbsp;-Ameett

nmrao · Answer

In that case, how it is coming 2 day before's date? or difference?

ameett · Answer

I will check once again if any application is in between.&nbsp;But if we assume that there is an application in between what needs to be check?&nbsp;There is one another operation - Get customer - if we provide the custid to it, it gives the correct date in the response.&nbsp;ThanksAmeett&nbsp;&nbsp;

sachintha · Answer

Hi nmrao&nbsp;
&nbsp;
I had that u mentioned issue,
&nbsp;
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.
&nbsp;
Ex:- SQL management result&nbsp; 2018-05-10
&nbsp; &nbsp; &nbsp; &nbsp; SoapUI JDBC result&nbsp; &nbsp; &nbsp; &nbsp; 2018 - 05 - 08
&nbsp;
can you help me?

Forum Discussion

JDBC request Test step Response has incorrect dates

Recent Discussions

SoapUI 5.9.0 released

OS SoapUI: Can it connect and use Cosmos DB

"Clone interface" between projects not working

Related Content

TestComplete recording incorrect button

Saving request and response

Empty response (request in python)