How to convert julian date to dd/mm/Y

[kavyamohan]

SVSCPLEX,S0W1,S0W1.DAL-EBIS.IHOST.COM,SYSLOG,zOS-SYSLOG-Console,SYSLOG,-0400,NE,001C,19283 01.21.46.880 -0500,S0W1 ,JOB03487, ,40000000000000000000000000000000,00000090,TESCREAT,00," IEF450I TESCREAT STEP010 - ABEND=S222 U0000 REASON=00000000"\n.

where, 19283 is julian date. I need to convert this to dd/mm/Y Is that possible?

[kamlesh_vaghela · Accepted solution]

@kavyamohan

Can you please try this?

| makeresults 
| eval jdate="19283",epoch_date=strptime(jdate,"%y%j"),date=strftime(epoch_date,"%d/%m/%Y") | table jdate date

[kavyamohan]

Thanks, it worked

[kamlesh_vaghela]

Glad to help you.

Happy Splunking

[kavyamohan]

yes i have updated question

[kamlesh_vaghela]

@kavyamohan

Need more clarity:

As per the http://www.longpelaexpertise.com/toolsJulian.php .

Julian Date: 19283
which is Date: 10-Oct-2019. It is giving the only date not %H:%M:%S . Can you please let us know your expected output ??

[kavyamohan]

Sorry. It was my mistake. I need Julian Date: 19283 to this format 10/10/2019

[kamlesh_vaghela]

It would be really helpful for others if you update the question. 🙂