All Apps and Add-ons

DB Connect - How to convert varchar to date/time format

joesrepsolc
Communicator

Working on a new data input in DB Connect with SQL Server. Date column is called "start_time" and is a 19 digit format for a date/time.

Example:

start_time = 20190206170328159

Definitiion Breakdown:
2019 02 06 17 03 28 159
yyyy MM dd HH mm ss SSS

Need it converted to a normal date/time format that Splunk can use for the timestamp. Anyone able to help with correct convert SQL statement?

Help

Thanks! Joe

0 Karma
Get Updates on the Splunk Community!

Splunk + ThousandEyes: Correlate frontend, app, and network data to troubleshoot ...

 Are you tired of troubleshooting delays caused by siloed frontend, application, and network data? We've got a ...

Splunk Observability for AI

Don’t miss out on an exciting Tech Talk on Splunk Observability for AI!Discover how Splunk’s agentic AI ...

🔐 Trust at Every Hop: How mTLS in Splunk Enterprise 10.0 Makes Security Simpler

From Idea to Implementation: Why Splunk Built mTLS into Splunk Enterprise 10.0  mTLS wasn’t just a checkbox ...