TO_TIMESTAMP(date, time) missing seconds?

Question

When I run log parser using the code below I get the data and time field together as expected but it is missing the seconds. How do you get it to also list the seconds? The two fields look like,

date time
3/13/2013 0:00:02

Once I run it using the code below it looks like this but is missing the seconds,

timestamp
3/13/2013 0:00

LogParser "SELECT  TO_TIMESTAMP(date, time) as timestamp INTO iisLog.csv FROM \\appdev1\c$\inetpub\logs\LogFiles\W3SVC1\u_ex130313.log" -i:iisW3C -o:csv

score 1 · Answer 1 · answered Jun 08 '13 at 19:54

1

Those date and time fields do not look to be of type TIMESTAMP, they've been likely parsed as STRING types. Use TO_TIMESTAMP(STRCAT(date, ' ', time), 'M/dd/yyyy H:mm:ss').

answered Jun 08 '13 at 19:54

Gabriele Giuseppini

156
1

1

Annoyingly, LogParser's `STRCAT` only supports calls with exactly 2 arguments. – Brian May 09 '18 at 14:01
Ooops, you're right. The unreleased 2.3 version does support multiple arguments :-) – Gabriele Giuseppini May 11 '18 at 12:11

TO_TIMESTAMP(date, time) missing seconds?

1 Answers1