DB tool resultset format issue
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
-
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.
1 -
Hi there, did anybosy used Neoforje databse and on integrating with SOA Test? if you can share anyinputs, I would appreciate.
0 -
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/
0 -
ok let me try it out
0
