Forum Discussion

sstevens's avatar
sstevens
New Contributor
8 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">     ...
Nastya_Khovrina's avatar
Nastya_Khovrina
Icon for Alumni rankAlumni
8 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
8 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