Archive
Highlighted

DB Connect: How to load database timestamp data in to Splunk?

when i am trying to load DB data in to splunk. Timestamp column ( TIMESTAMP(6) WITH TIME ZONE ) data is loading as empty.
Do i need to do any settings for the column in splunk DB input?

0 Karma
Highlighted

Re: DB Connect: How to load database timestamp data in to Splunk?

Motivator

Which type of DB is this? SQL? You might want to try

cast( <TIMEfield>AS DATETIME)<fieldname>
0 Karma
Highlighted

Re: DB Connect: How to load database timestamp data in to Splunk?

Splunk Employee
Splunk Employee

Hi. You might want to have a look at these docs, which discuss best practices for timestamps and database output:
http://docs.splunk.com/Documentation/DBX/1.1.4/DeployDBX/Configuredatabasemonitoring#About_timestamp...