search

JamesSkemp / logparserplus.com

Web site content for logparserplus.com
4 stars 0 forks source link

TO_TIMESTAM function does not recognize MMM - 3 char abreviation #2

Closed cristiangabor closed 4 years ago

cristiangabor commented 4 years ago

The following date '24 Jun 2011 13:22:21', 'dd MMM yyyy HH:mm:ss' fails to return a timestamp due to MMM not being able to recognize the 3 Month abbreviation

Please fix it

JamesSkemp commented 4 years ago

Hi Cristian.

Unfortunately I can't replicate that.

.\LogParser.exe "select top 1 TO_TIMESTAMP('24 Jun 2011 13:22:21', 'dd MMM yyyy HH:mm:ss') from '\path\to\u_ex19*.log'"

Can you provide the full query so I can try to repeat it on my end?

JamesSkemp commented 4 years ago

Before I close this, wanted to follow-up one more time. :)

JamesSkemp commented 4 years ago

Closing this out, but don't hesitate to reach out with the full query, if you still can't get it to work.