My input timestamp is in the format "yyyy-mm-dd hh:mm:ss.6additional digits". I need to convert this into the format
"yyyy-mm-dd-hh.mm.ss.6additionaldigits". This has to be done through groovyscripting.
eg : I ran the below code but get an error
def soaprep = "2014-02-11 22:57:12.650224"
def soapform= new Date().parse("yyyy-mm-dd hh:mm:ss.SSSSSS",soaprep)
log.info soapform
def formattime = soapform.format("yyyy-mm-dd-hh.mm.ss.SSSSSS")
log.info formattime
Results (which is not what I expect)
soapform =Sat jan 11 23:08:02 CST 2014
formattime = 2014-08-11-23:08:02.000224
My expected result is 2014-02-11-22.57.12.650224
Hi,
This is a piece of code which seems to do what you want:
import java.text.SimpleDateFormat // This was your String def soaprep = "2014-02-11 22:57:12.650224" // Define the format for the date SimpleDateFormat sdf = new SimpleDateFormat( "yyyy-mm-dd hh:mm:ss.SSSSSS" ) // Convert to date Date yourDate = sdf.parse( soaprep ) // Display with the desired format sdf.format(yourDate)
But I am curious why would you need something like this.
The expected format is the output from another application which I need to compare with . Hence require my input to be in that format
The above code doesnot give me the correct result. It returns the time incorrectly. I want the same values in the response just with additional hyphen and semicolon changed to a dot.
import java.text.SimpleDateFormat // This was your String def soaprep = "2014-02-11 22:57:12.650224" // Define the format for the date SimpleDateFormat sdf = new SimpleDateFormat( "yyyy-mm-dd hh:mm:ss.SSSSSS" ) // Convert to date Date yourDate = sdf.parse( soaprep ) // Define a new format SimpleDateFormat newFormat = new SimpleDateFormat( "yyyy-mm-dd-hh.mm.ss.SSSSSS" ) // Display with the desired format newFormat.format(yourDate)
I don't really understand the use case for this but it doesn't look like the right way to do it. Anyways, the above code should do it.
You may be right. May be this is not the right way. This timstamp has additional 6 digits which I donot know what they represent. Hence even with the code you gave I get an incorrect value for the time field .
Instead of the expected result 2014-02-11-22.57.12.650224, I get the value as 2014-02-11-11.08.02.000224
Is there anyway I can convert the string 2014-02-11 22:57:12.650224 to the format 2014-02-11-22.57.12.650224.
I think the last 6 digit value is in milliseconds but the SimpleDateFormater only works with 3 digits (not 100% sure). Is it acceptable to trim the last 3 digits?
Yes, the last six numbers are milliseconds. With a DB2 database, the output format for a timestamp (when queried) is "2014-02-11 22:57:12.650224", but if you need to set a timestamp, you have to format it "2014-02-11-22.57.12.650224".
Since this is just a string, try:
def ts = "2014-02-11 22:57:12.650224"
// Replace space with dash ts = ts.replaceAll( " ", "-" ) // Replace colons with periods ts = ts.replaceAll( ":", "." ) log.info ts
Yes. Thank you