Forum Discussion

sstevens's avatar
sstevens
New Contributor
7 years ago

JDBC Response date format assertion diffs that dont include ".0" at the end of the string

Im perplexed by an issue with regards to JDBC Test Step responses   It is specific to the Response XML on date columns:   The JDBC response XML:   <Results>    <ResultSet fetchSize="10">     ...
skelander's avatar
skelander
Occasional Contributor
6 years ago

Hello!

 

I am having the exakt same problem. I am using ReadyAPI 2.2.0.

 

When executing the same sql via Oracle SQL Developer (we are runing Oracle Database 12c) I get the date without the .0 in the end.

 

Not a big problem, but slightly annoying :)

 

 

Cheers,

Rikard

  • Nastya_Khovrina's avatar
    Nastya_Khovrina
    SmartBear Alumni (Retired)
    6 years ago

    Hi,

     

    If a value has the Date format in the Database (i.e. 2018-05-23 00:00:00), the JDBC Test Step Request will return it with ".0" in the Response. Java returns it in a such format and ReadyAPI doesn't support formatting dates, taken from the DB.

    As a workaround, you can write the desired format in the SQL Query, for example:
    Select TO_CHAR(PATH, FORMAT)

     

    where PATH - SQL path to the field, which needs to be formatted
    FORMAT - the needed date format, for example: 

    'YYYY-MM-DD HH24:MI:SS' 

     

    • richie's avatar
      richie
      Community Hero
      6 years ago

      Hi,

       

      that will help skelander, because he's using Oracle - but sstevens didn't mention the RDBMS he's using.

       

      If sstevens is using a different RDBMSs then this won't work will it?

       

      if it's SQLServer you might have to use the CONVERT method or getDate or something like that.

       

      Cheers,

       

      richie