Skip to content

Nanoseconds missing functions #6224

@javier

Description

@javier

Is your feature request related to a problem?

Most timestamp functions work with nanos, but there are a couple of missing functions

now_ns(). We do have systimestamp_ns, but now is slightly different
extract() -- does not support extracting "nanoseconds"
rnd_timestamp_ns -- we have random for the rest of data types
timestamp_sequence_ns -- We have timestamp_ns, which accepts timestamp_ns, but the step is always in microseconds. We need this version that accepts the step in nanoseconds.

Describe the solution you'd like.

No response

Describe alternatives you've considered.

No response

Full Name:

javier

Affiliation:

QuestDB

Additional context

No response

Metadata

Metadata

Assignees

Labels

New featureFeature requestsSQLIssues or changes relating to SQL executioninternal

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions