All Apps and Add-ons

How do I configure Splunk DB Connect 2 get the proper EST timestamp from my Oracle table instead of EST +5:30?

snehalk
Communicator

Hello Everyone,

Am using the Splunk DB Connect 2 application for the taking Oracle data into Splunk. For assigning the Time stamp, I am facing the difficulties because if I go with clicking Output timestamp option and assigning the table column value that is "starttime", then it's taking that value, but it is showing EST+5:30 hour, but I need to have system time that is EST.

If I go with the default one, even for that it is taking EST+5:30 instead of EST.

Please help me on this. How do I get the table data into Splunk with the EST time stamp?

Thanks,

0 Karma

woodcock
Esteemed Legend

Normalize time time in SQL to EST and append the TZ string before you import it like this:

select CONVERT(datetime,SWITCHOFFSET(CONVERT(datetimeoffset,getdate()),'+05:30')) starttime + ' EST'
Get Updates on the Splunk Community!

Index This | I am a number, but when you add ‘G’ to me, I go away. What number am I?

March 2024 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with another ...

What’s New in Splunk App for PCI Compliance 5.3.1?

The Splunk App for PCI Compliance allows customers to extend the power of their existing Splunk solution with ...

Extending Observability Content to Splunk Cloud

Register to join us !   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to ...