Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Appearance settings

New Rule for format masks (eg for to_date) #100

Copy link
Copy link
Closed
@S-Koell

Description

@S-Koell
Issue body actions

When using to_date with a format mask I think most people assume that the format mask is enforced ... which it isnt (see attached screenshot).
Also leaving out numbers wont always result in an exception.

So my suggestion would be to always use ‚FX‘ in front of a format mask to enforce the mask except you need it to be ‚fuzzy‘.
See docs:
https://docs.oracle.com/en/database/oracle/oracle-database/21/sqlrf/Format-Models.html#GUID-7FF68D9E-C7E2-4CA1-9DDB-5CC7169EEEEA

IMG_7992

Metadata

Metadata

Assignees

No one assigned

    Labels

    enhancementNew feature or requestNew feature or request

    Type

    No type

    Projects

    No projects

    Milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions

      Morty Proxy This is a proxified and sanitized view of the page, visit original site.