All Apps and Add-ons
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Ask a Question

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

joesrepsolc
Communicator
‎04-30-2019 11:42 AM

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
Reply
Get Updates on the Splunk Community!

Modern way of developing distributed application using OTel

Recently, I had the opportunity to work on a complex microservice using Spring boot and Quarkus to develop a ...

Enterprise Security Content Update (ESCU) | New Releases

Last month, the Splunk Threat Research Team had 3 releases of new security content via the Enterprise Security ...

Archived Metrics Now Available for APAC and EMEA realms

We’re excited to announce the launch of Archived Metrics in Splunk Infrastructure Monitoring for our customers ...