[MDEV-20017] Implement TO_CHAR() Oracle compatible function - Jira

XML

Word

Printable

Details

Type: Technical task
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: None
Fix Version/s: 10.6.1
Component/s: Server
Labels:
- Compatibility

Description

This function is overloaded and supports NUMBER, DATE, DATETIME, TIMESTAMP etc as parameters and returns a formatted/converted TEXT value

https://docs.oracle.com/cd/B28359_01/olap.111/b28126/dml_functions_2113.htm#OLADM691

This is currently not available under ORACLE compatibility mode.

Attachments

Attachments

- Sort By Name
- Sort By Date
- Ascending
- Descending
- Thumbnails
- List
- Download All

10.6-to_char_01_13.patch
54 kB
2021-01-20 14:17
10.6-to_char.patch
28 kB
2021-01-05 00:45
tochar-reviewed.patch
59 kB
2021-01-25 12:12

Issue Links

blocks

MDEV-10342 Providing compatibility for basic SQL built-in functions

Closed

relates to

MDEV-25697 TO_CHAR does not take into account capitalization in format elements

Open

MDEV-28136 MariaDB ASAN Unknown Crash in Item_func_to_char::parse_format_string

Closed

Activity

People

Assignee:: Michael Widenius

Reporter:: Faisal Saeed (Inactive)

Votes:: 0 Vote for this issue

Watchers:: 7 Start watching this issue

Dates

Created:: 2019-07-10 16:00

Updated:: 2022-03-21 10:58

Resolved:: 2021-05-20 09:29

Time Tracking

Estimated:

10d

Remaining:

0d

Logged:

1d 6.5h

Git Integration

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