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
7 years ago
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.