mirror of
https://github.com/MariaDB/server.git
synced 2025-07-04 18:38:14 +02:00
2dc9b8b78e
Adding support for the "FM" format in function TO_CHAR(date_time, fmt).
"FM" in the format string disables padding of all components following it.
So now TO_CHAR() works as follows:
- By default string format components DAY (weekday name) and
MONTH (month name) are right-padded with spaces to the maximum
possible DAY and MONTH name lengths respectively,
according to the current locale specified in @@lc_time_names.
So for example, with lc_time_names='en_US' all month names are
right-padded with spaces up to 9 characters ('September' is the longest).
SET lc_time_names='en_US';
SELECT TO_CHAR('0001-02-03', 'MONTH'); -> 'February ' (padded to 9 chars)
NEW: When typed after FM, DAY and MONTH names are not right-padded
with trailing spaces any more:
SET lc_time_names='en_US';
SELECT TO_CHAR('0001-02-03', 'FMMONTH'); -> 'February' (not padded)
- By default numeric components YYYY, YYY, YY, Y, DD, H12, H24, MI, SS
are left-padded with leading digits '0' up to the maximum possible
number of digits in the component (e.g. 4 for YYYY):
SELECT TO_CHAR('0001-02-03', 'YYYY'); -> '0001' (padded to 4 chars)
NEW: When typed after FM, these numeric components are not left-padded
with leading zeros any more:
SELECT TO_CHAR('0001-02-03', 'FMYYYY'); -> '1' (not padded)
- If FM is specified multiple times in a format string,
every FM negates the previous padding state:
* an odd FM disables padding
* an even FM enables padding
Implementation details:
- Adding a helper class Date_time_format_oracle.
- Adding a helper method Date_time_format_oracle::append_lex_cstring()
- Moving the function append_val() to Date_time_format_oracle as a method.
- Moving the function make_date_time_oracle() to Date_time_format_oracle
as a method format().
- Adding helper methods month_name() and day_name() in class MY_LOCALE,
to return the corresponding components as LEX_CSTRINGs.
99 lines
3.2 KiB
C++
99 lines
3.2 KiB
C++
/* Copyright (c) 2006, 2010, Oracle and/or its affiliates. All rights reserved.
|
|
|
|
This program is free software; you can redistribute it and/or modify
|
|
it under the terms of the GNU General Public License as published by
|
|
the Free Software Foundation; version 2 of the License.
|
|
|
|
This program is distributed in the hope that it will be useful,
|
|
but WITHOUT ANY WARRANTY; without even the implied warranty of
|
|
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
|
|
GNU General Public License for more details.
|
|
|
|
You should have received a copy of the GNU General Public License
|
|
along with this program; if not, write to the Free Software
|
|
Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1335 USA */
|
|
|
|
#ifndef SQL_LOCALE_INCLUDED
|
|
#define SQL_LOCALE_INCLUDED
|
|
|
|
typedef struct my_locale_errmsgs
|
|
{
|
|
const char *language;
|
|
const char ***errmsgs;
|
|
} MY_LOCALE_ERRMSGS;
|
|
|
|
|
|
typedef struct st_typelib TYPELIB;
|
|
|
|
class MY_LOCALE
|
|
{
|
|
public:
|
|
uint number;
|
|
const char *name;
|
|
const char *description;
|
|
const bool is_ascii;
|
|
TYPELIB *month_names;
|
|
TYPELIB *ab_month_names;
|
|
TYPELIB *day_names;
|
|
TYPELIB *ab_day_names;
|
|
uint max_month_name_length;
|
|
uint max_day_name_length;
|
|
uint decimal_point;
|
|
uint thousand_sep;
|
|
const char *grouping;
|
|
MY_LOCALE_ERRMSGS *errmsgs;
|
|
MY_LOCALE(uint number_par,
|
|
const char *name_par, const char *descr_par, bool is_ascii_par,
|
|
TYPELIB *month_names_par, TYPELIB *ab_month_names_par,
|
|
TYPELIB *day_names_par, TYPELIB *ab_day_names_par,
|
|
uint max_month_name_length_par, uint max_day_name_length_par,
|
|
uint decimal_point_par, uint thousand_sep_par,
|
|
const char *grouping_par, MY_LOCALE_ERRMSGS *errmsgs_par) :
|
|
number(number_par),
|
|
name(name_par), description(descr_par), is_ascii(is_ascii_par),
|
|
month_names(month_names_par), ab_month_names(ab_month_names_par),
|
|
day_names(day_names_par), ab_day_names(ab_day_names_par),
|
|
max_month_name_length(max_month_name_length_par),
|
|
max_day_name_length(max_day_name_length_par),
|
|
decimal_point(decimal_point_par),
|
|
thousand_sep(thousand_sep_par),
|
|
grouping(grouping_par),
|
|
errmsgs(errmsgs_par)
|
|
{}
|
|
my_repertoire_t repertoire() const
|
|
{ return is_ascii ? MY_REPERTOIRE_ASCII : MY_REPERTOIRE_EXTENDED; }
|
|
/*
|
|
Get a non-abbreviated month name by index
|
|
@param month - the month index 0..11
|
|
*/
|
|
LEX_CSTRING month_name(uint month) const
|
|
{
|
|
if (month > 11)
|
|
return Lex_cstring("##", 2);
|
|
return Lex_cstring_strlen(month_names->type_names[month]);
|
|
}
|
|
/*
|
|
Get a non-abbreviated weekday name by index
|
|
@param weekday - the weekday index 0..6
|
|
*/
|
|
LEX_CSTRING day_name(uint weekday) const
|
|
{
|
|
if (weekday > 6)
|
|
return Lex_cstring("##", 2);
|
|
return Lex_cstring_strlen(day_names->type_names[weekday]);
|
|
}
|
|
};
|
|
/* Exported variables */
|
|
|
|
extern MY_LOCALE my_locale_en_US;
|
|
extern MYSQL_PLUGIN_IMPORT MY_LOCALE *my_locales[];
|
|
extern MY_LOCALE *my_default_lc_messages;
|
|
extern MY_LOCALE *my_default_lc_time_names;
|
|
|
|
/* Exported functions */
|
|
|
|
MY_LOCALE *my_locale_by_name(const char *name);
|
|
MY_LOCALE *my_locale_by_number(uint number);
|
|
void cleanup_errmsgs(void);
|
|
|
|
#endif /* SQL_LOCALE_INCLUDED */
|