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?
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...
Which type of DB is this? SQL? You might want to try
cast( <TIMEfield>AS DATETIME)<fieldname>