MonitorWare Knowledge Base

Hi,

I need to extract the timeDate value from a syslog message
The interesting part of the message is

... start_time="2006-07-22 13:39:41" duration=4 ...

The " " are making it not easy to extract this value and store it in SQL as a dateTime (smalldatetime) value
Do I need to extract this as a ISO time or as a UNIX time?
Do I need to include the " or not?

Can anybody help with this?

Thanks

Daniel

Hi,

you should be able to parse this value as "ISO-like timestamp", then it is possible to write it into a database as datetime value.

It is also not hard to parse this values, take a look to the following article which explains very well how to parse such messages:
http://www.monitorware.com/Common/en/Ar ... ssages.php

best regards,
Andre Lorbach