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.

After executing JDBC request test step a response is returned which I am verifying with XQuery assertion

 

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, 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

             date in response = 2017-05-30

date format is - yyyy-mm-dd

 

May I request you to please help me regarding this?

If possible could anyone please reply fast, as it is bit urgent

 

Thanks

-Ameett

  • nmrao's avatar
    nmrao
    Champion Level 3
    8 years ago
    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's avatar
      ameett
      Contributor
      8 years ago

      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?