Details

    • Type: Improvement
    • Status: Resolved
    • Priority: Minor
    • Resolution: Duplicate
    • Affects Version/s: 0.11.0
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None

      Description

      You have the equivalent scalar functions but do not offer ISO-SQL extract which should be a small enhancement.

      Note, the second() scalar does not return the fractional seconds in a timestamp with ISO-SQL would expect extract (second) to implement.

      select extract (year from cts), ....

      vs

      select rnum, year (cts), month( cts), day( cts), hour(cts), minute (cts), second( cts), cts from tts

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                the6campbells N Campbell
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: