[MDEV-35972] Oracle: Function TO_DSINTERVAL() - Jira

XML

Word

Printable

TO_DSINTERVAL converts its argument to a value of the INTERVAL DAY TO SECOND data type.

The grammar and syntax rules:

TO_DSINTERVAL <left paren> <expr> [ DEFAULT <expr> ON CONVERSION ERROR ] <right paren>

Both <expr> instances should evaluate to a character string data type (CHAR,VARCHAR,TEXT) with a value matching <ds format>.
The optional DEFAULT clause allows to specify the value returned in case if an error happens while converting the argument.

<ds format> := <ds format sql> | <ds format iso>

<ds format sql> := <sign> <days> <space> <hours> : <minutes> : <seconds> [. frac_seconds ]

<ds format iso> := [<minus sign>] P [<days> D] [T [<hours> H] [<minutes> M] [<seconds> [<period> <frac seconds>] S ] ]

<days>         := <unsigned integer>

<hours>        := <unsigned integer>

<minutes>      := <unsigned integer>

<seconds>      := <unsigned integer>

<frac seconds> := <unsigned integer>

TODO

is part of

MDEV-35973 Oracle Compatibility Project 1 for 2025

relates to

MDEV-12513 GSoC: INTERVAL data type

links to

TO_DSINTERNAL in Oracle docs

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.