Submit and vote on feature ideas.

Welcome to the new Parasoft forums! We hope you will enjoy the site and try out some of the new features, like sharing an idea you may have for one of our products or following a category.

DB tool resultset format issue

Options
jyothikilaru
jyothikilaru Posts: 6 ✭
in SOAtest

This is the format that we r receiving for a filed from Toad: 01/09/2018
but we are getting (2018-02-15 00:00:00.0)format from DB tool result set. How can we change the format to month/date/year like the way that we are getting in Toad?

Thanks

Comments

  • jakubiak
    jakubiak Posts: 798 admin
    Options

    I think there are two different ways you could handle this. One would be to modify your SQL query to return the date in the result set in a different format. The other would be to post-process the date in SOAtest using a script (like in an Extension Tool) to put it in the format you expect. Here is a post that briefly discusses the two different approaches - you may need to change the details for your specific case.

    https://stackoverflow.com/questions/31404680/how-to-format-and-display-date-from-database-using-resultset

  • Lakshmi20020
    Lakshmi20020 Posts: 9 ✭
    Options

    Hi there, did anybosy used Neoforje databse and on integrating with SOA Test? if you can share anyinputs, I would appreciate.

  • benken_parasoft
    benken_parasoft Posts: 1,231 ✭✭✭
    edited October 2018
    Options

    did anybosy used Neoforje databse

    Do you mean neo4j? SOAtest supports JDBC. Did you try using their JDBC driver? The driver class name appears to be "org.neo4j.jdbc.Driver" and the connection URL appears to be something like "jdbc:neo4j:bolt://\<host>:\<port>/" based on their docs: http://neo4j-contrib.github.io/neo4j-jdbc/

  • Lakshmi20020
    Lakshmi20020 Posts: 9 ✭
    Options

    ok let me try it out

Categories