Getting Data In

Need to convert the timezone dynamically

manojchacko78
Path Finder

Hello there,

I would like to convert the  default time to the local country timezone and place the converted timezone next to the default one

The defaut timezone is Central European time and based on the country name available in the report, need to conver the timezone. I guess i need to have a lookup table which the coutryname and the timezone of that country

Timestamp

CountryCode

CountryName

Region

2023-10-29T13:15:51.711ZBRBrazilAmericas
2023-10-30T10:13:19.160ZBHBahrainAPEC
2023-10-30T19:15:24.263ZAEArab EmiratesAPEC

 

Labels (1)
Tags (3)
0 Karma
1 Solution

richgalloway
SplunkTrust
SplunkTrust

Splunk doesn't really offer a means to convert time zones since each user has the ability to set their own preferred time zone.

If you really want to do it, then your lookup table will need to provide the offset from the default time zone to the local country time zone.  The you should be able to pass that value to the relative_time function.

---
If this reply helps you, Karma would be appreciated.

View solution in original post

richgalloway
SplunkTrust
SplunkTrust

Splunk doesn't really offer a means to convert time zones since each user has the ability to set their own preferred time zone.

If you really want to do it, then your lookup table will need to provide the offset from the default time zone to the local country time zone.  The you should be able to pass that value to the relative_time function.

---
If this reply helps you, Karma would be appreciated.

manojchacko78
Path Finder

Worked, thanks

Get Updates on the Splunk Community!

Understanding Generative AI Techniques and Their Application in Cybersecurity

Watch On-Demand Artificial intelligence is the talk of the town nowadays, with industries of all kinds ...

.conf24 | Registration Open!

Hello, hello! I come bearing good news: Registration for .conf24 is now open!   conf is Splunk’s rad annual ...

Using the Splunk Threat Research Team’s Latest Security Content

REGISTER HERE Tech Talk | Security Edition Did you know the Splunk Threat Research Team regularly releases ...