https://community.splunk.com/t5/All-Apps-and-Add-ons/DB-Connect-How-to-load-database-timestamp-data-in-to-Splunk/m-p/137082#M72037 <P>Which type of DB is this? SQL? You might want to try </P> <PRE><CODE>cast( &lt;TIMEfield&gt;AS DATETIME)&lt;fieldname&gt; </CODE></PRE> Tue, 23 Sep 2014 17:08:20 GMT theouhuios 2014-09-23T17:08:20Z https://community.splunk.com/t5/All-Apps-and-Add-ons/DB-Connect-How-to-load-database-timestamp-data-in-to-Splunk/m-p/137081#M72036 <P>when i am trying to load DB data in to splunk. Timestamp column ( TIMESTAMP(6) WITH TIME ZONE ) data is loading as empty.<BR /> Do i need to do any settings for the column in splunk DB input? </P> Tue, 23 Sep 2014 16:43:16 GMT https://community.splunk.com/t5/All-Apps-and-Add-ons/DB-Connect-How-to-load-database-timestamp-data-in-to-Splunk/m-p/137081#M72036 nagaraju_varkal 2014-09-23T16:43:16Z https://community.splunk.com/t5/All-Apps-and-Add-ons/DB-Connect-How-to-load-database-timestamp-data-in-to-Splunk/m-p/137082#M72037 <P>Which type of DB is this? SQL? You might want to try </P> <PRE><CODE>cast( &lt;TIMEfield&gt;AS DATETIME)&lt;fieldname&gt; </CODE></PRE> Tue, 23 Sep 2014 17:08:20 GMT https://community.splunk.com/t5/All-Apps-and-Add-ons/DB-Connect-How-to-load-database-timestamp-data-in-to-Splunk/m-p/137082#M72037 theouhuios 2014-09-23T17:08:20Z https://community.splunk.com/t5/All-Apps-and-Add-ons/DB-Connect-How-to-load-database-timestamp-data-in-to-Splunk/m-p/137083#M72038 <P>Hi. You might want to have a look at these docs, which discuss best practices for timestamps and database output:<BR /> <A href="http://docs.splunk.com/Documentation/DBX/1.1.4/DeployDBX/Configuredatabasemonitoring#About_timestamps_and_database_output">http://docs.splunk.com/Documentation/DBX/1.1.4/DeployDBX/Configuredatabasemonitoring#About_timestamps_and_database_output</A></P> Tue, 23 Sep 2014 17:17:54 GMT https://community.splunk.com/t5/All-Apps-and-Add-ons/DB-Connect-How-to-load-database-timestamp-data-in-to-Splunk/m-p/137083#M72038 sroback_splunk 2014-09-23T17:17:54Z