Parse Date Format


Author
Message
Brad Konia
Brad Konia
Forum Expert (806 reputation)Forum Expert (806 reputation)Forum Expert (806 reputation)Forum Expert (806 reputation)Forum Expert (806 reputation)Forum Expert (806 reputation)Forum Expert (806 reputation)Forum Expert (806 reputation)Forum Expert (806 reputation)
Group: Forum Members
Posts: 70, Visits: 111
What would be the correct format string to parse the following date:

2021-07-30T13:28:30.942654-04:00

The wizard generates the following string:

yyyy-MM-ddT%H:mm:ss.ffffffzzzz

However, when I view the result in the log viewer, there's no time zone column, and the time is displayed like:

1:28:30 PM.942
Replies
Brad Konia
Brad Konia
Forum Expert (806 reputation)Forum Expert (806 reputation)Forum Expert (806 reputation)Forum Expert (806 reputation)Forum Expert (806 reputation)Forum Expert (806 reputation)Forum Expert (806 reputation)Forum Expert (806 reputation)Forum Expert (806 reputation)
Group: Forum Members
Posts: 70, Visits: 111
It seems the problem is LVP is unable to parse Linux time zones like America/New_York. This is a pretty common logging format on Linux. Do you think you could support this?
LogViewPlus Support
LogViewPlus Support
Supreme Being (12K reputation)Supreme Being (12K reputation)Supreme Being (12K reputation)Supreme Being (12K reputation)Supreme Being (12K reputation)Supreme Being (12K reputation)Supreme Being (12K reputation)Supreme Being (12K reputation)Supreme Being (12K reputation)
Group: Moderators
Posts: 1.2K, Visits: 4.3K
Unfortunately, no.  LogViewPlus time zone logic uses the work done by Microsoft which only supports the zzzz time zone formats (UTC offsets of +/-0100, etc...).  LogViewPlus enhances this with the formatter ZZZ to handle three letter time zones like GMT and EST, but it is difficult to see how this could be extended to handle geographies like "America/New_York" without significant effort.

For the moment, we need to focus our attention on other areas of the application.

Thanks for the suggestion,

Toby
GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...





Similar Topics

Login

Explore
Messages
Mentions
Search