Cannot convert string to timestamp

 
1
0
-1

Hi Team,


Please help adapt the script for the date field to synchronize between Jira and Exalate for SNOW. I`m receiving string value from SNOW and how I can apply it to the timestamp in Jira. Also vise versa accordingly


See date format in SNOW - 01/17/2022 07:38:08

and Jira - 11/Jan/22 5:47 PM


I saw one topic in community but it did not help - Integrate ServiceNow and Jira SD: date/time field issue


Thank you

    CommentAdd your comment...

    1 answer

    1.  
      1
      0
      -1

      Hi Taras,



      Stackoverflow to the rescue - check out this article

      Also the web based groovy console is very useful if you want to experiment

      I pasted there following code (from that stackoverflow document)

      import java.text.SimpleDateFormat
import java.sql.Timestamp

String st = "16/08/2007 09:04:34"    
SimpleDateFormat sdf = new SimpleDateFormat("dd/mm/yyyy hh:mm:ss")     
Date date = sdf.parse(st)     
Timestamp timestamp = new Timestamp(date.getTime())     
t2 = timestamp.toString()
​print t2

      Which gave

      1. Taras Botsko

        Thanks for the guidance Francis, I have one more clarification.

        It works when a date string suit format we try to parse  "16/08/2007 09:04:34" to "dd/mm/yyyy hh:mm:ss"


        But how it will work in my case I need to parse string "16/08/2007 09:04:34" to "dd/MMM/yy h:mm a"


        Maybe I`m missing something(


        Thanks

      2. Francis Martens (Exalate)

        Do you want to convert 16/08 to 16/Aug ?


        With the code above you can convert the source datestring into a timestamp, and then with the date formatting methods, you can the convert it back into a specific formatted datestring...

      3. Taras Botsko

        yeah, I have difficulties on how to format date from "mm/dd/yyyy hh:mm:ss" to "dd/MMM/yy h:mm a". I was searching in Stackoverflow but it does work. I also will ask our local Java dev to help on it. But if you have a working code, it will help. I`ll share here if I will find something as well. Thanks

      4. Francis Martens (Exalate)

        Euh - you're passing the joy of hacking around


        Try this

        ​import java.text.SimpleDateFormat
import java.sql.Timestamp

String st = "16/08/2007 09:04:34"    
SimpleDateFormat sourceSDF = new SimpleDateFormat("dd/mm/yyyy hh:mm:ss")     
Date date = sourceSDF.parse(st)     


SimpleDateFormat targetSDF = new SimpleDateFormat("dd/MMM/yyyy hh:mm:ss")     
println "Results in " + targetSDF.format(date)     


Timestamp timestamp = new Timestamp(date.getTime())     
t2 = timestamp.toString()
println t2
      5. Taras Botsko

        Thank you Francis, that works perfectly!

        One thing is when I set String st = replica.start_date where replica.start_date is a String. I`m receiving exalate error - unable to parse "".

        In line 

        Date date = sourceSDF.parse(st) 

        I`ll test it further and let here know

        Thanks again for a help
      6. Taras Botsko

        Fixed! Thanks so much for your support! I added an additional variable


        import java.text.SimpleDateFormat
import java.sql.Timestamp

def startDate = replica.start_date
String st = startDate   
SimpleDateFormat sourceSDF = new SimpleDateFormat("mm/dd/yyyy hh:mm:ss")     
Date date = sourceSDF.parse(st)        
SimpleDateFormat targetSDF = new SimpleDateFormat("dd/MMM/yy h:mm a")
Timestamp timestamp = new Timestamp(date.getTime())

issue.customFields."Start Date".value = timestamp
      CommentAdd your comment...