-
Notifications
You must be signed in to change notification settings - Fork 15
Closed
Labels
StandardizationStandardization Job affectedStandardization Job affectedbugSomething isn't workingSomething isn't workingpriority: highCritical to the health of the projectCritical to the health of the project
Description
Describe the bug
The pattern for timestamp parsing does not allow to handle micro-/nanoseconds.
To Reproduce
Input values of the following type (common output from many DBs) cannot be Standardized to timestamp:
"21-MAR-2019 19:00:00.223001"
Expected behaviour
The input can be handled. at least with loss of precision.
Possible solutions
- Keyword for this type, (like
epoch) able to handling it - own pattern placeholders (u for microseconds, n for nanoseconds), where the result looses precision to milliseconds (internally use
SSSpattern placeholder after trimming the extra digits - udf able of better casting (hint for solution)
Related issues
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
StandardizationStandardization Job affectedStandardization Job affectedbugSomething isn't workingSomething isn't workingpriority: highCritical to the health of the projectCritical to the health of the project