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

[nagaraju_varkal]

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?

[sroback_splunk]

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...

[theouhuios]

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

cast( <TIMEfield>AS DATETIME)<fieldname>