Forum Discussion

N78A's avatar
N78A
Contributor
7 years ago

Converting value of timestamp to expected format - groovy Soapui

I am trying to convert value of timestamp fetched from hive database to an expected format. Can some one please help !   Timestamp fetched :   TRANSACTION_TIMESTAMP>20170210141809</TRANSACTION_TI...
JHunt's avatar
JHunt
Community Hero
String s = '20170210141809'
Date myDate = Date.parse('yyyyMMddHHmmss', s)
assert myDate.format('yyyy-MM-dd HH:mm:') == '2017-02-10 14:18:'

 

N78A's avatar
N78A
Contributor
7 years ago
Hi, Thanks for your response. I tried the method you suggested, but it gives me error : "unparseable date"
  • JHunt's avatar
    JHunt
    Community Hero
    7 years ago

    My script didn't work?

     

    I presumed you made a typo when you said that you fetched the timestamp in this format:

     

    TRANSACTION_TIMESTAMP>20170210141809</TRANSACTION_TIMESTAMP

    So I was working on the basis of just starting from:

    20170210141809

    If you had to start from the top one, you could just do this to get to the second one:

     

    String s = 'TRANSACTION_TIMESTAMP>20170210141809</TRANSACTION_TIMESTAMP'
Date myDate = Date.parse('yyyyMMddHHmmss', s[22..35])
assert myDate.format('yyyy-MM-dd HH:mm:') == '2017-02-10 14:18:'

    That would get it working, but in that case perhaps it would be better to work on the way you are getting hold of the dates? Perhaps you could post that part of your code.

     

    • N78A's avatar
      N78A
      Contributor
      7 years ago

      Hi,

       

      Thanks again.

      Sorry I couldnt try again the solution suggested. Will check and come back.