Skip to content

Standardization cannot parse input with micro- or nanoseconds #466

@benedeki

Description

@benedeki

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 SSS pattern placeholder after trimming the extra digits
  • udf able of better casting (hint for solution)

Related issues

#465
#380

Metadata

Metadata

Assignees

Labels

StandardizationStandardization Job affectedbugSomething isn't workingpriority: highCritical to the health of the project

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions