Yu1709$!%yuyu!$%wutu!5=126+

                
____  ___       .__                 
\   \/  /  _____|  |   ______  _  __
 \     /  /  ___/  |  /  _ \ \/ \/ /
 /     \  \___ \|  |_(  <_> )     / 
/___/\  \/____  >____/\____/ \/\_/  
      \_/     \/    @ligmakokz

Editing: sql_time.h

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_TIME_INCLUDED
#define SQL_TIME_INCLUDED

#include "sql_basic_types.h"
#include "my_time.h"
#include "mysql_time.h"                         /* timestamp_type */
#include "sql_error.h"                          /* Sql_condition */
#include "structs.h"                            /* INTERVAL */

typedef enum enum_mysql_timestamp_type timestamp_type;
typedef struct st_date_time_format DATE_TIME_FORMAT;
typedef struct st_known_date_time_format KNOWN_DATE_TIME_FORMAT;

/* Flags for calc_week() function.  */
#define WEEK_MONDAY_FIRST    1
#define WEEK_YEAR            2
#define WEEK_FIRST_WEEKDAY   4

ulong convert_period_to_month(ulong period);
ulong convert_month_to_period(ulong month);
void set_current_date(THD *thd, MYSQL_TIME *to);
bool time_to_datetime(MYSQL_TIME *ltime);
bool get_date_from_daynr(long daynr,uint *year, uint *month, uint *day);
my_time_t TIME_to_timestamp(THD *thd, const MYSQL_TIME *t, uint *error_code);
bool str_to_datetime_with_warn(THD *thd,
                               CHARSET_INFO *cs, const char *str, size_t length,
                               MYSQL_TIME *l_time,
                               date_mode_t flags);
bool double_to_datetime_with_warn(THD *thd, double value, MYSQL_TIME *ltime,
                                  date_mode_t fuzzydate,
                                  const TABLE_SHARE *s, const char *name);
bool decimal_to_datetime_with_warn(THD *thd,
                                   const my_decimal *value, MYSQL_TIME *ltime,
                                   date_mode_t fuzzydate,
                                   const TABLE_SHARE *s, const char *name);
bool int_to_datetime_with_warn(THD *thd, const Longlong_hybrid &nr,
                               MYSQL_TIME *ltime,
                               date_mode_t fuzzydate,
                               const TABLE_SHARE *s, const char *name);

bool time_to_datetime(THD *thd, const MYSQL_TIME *tm, MYSQL_TIME *dt);
bool time_to_datetime_with_warn(THD *thd,
                                const MYSQL_TIME *tm, MYSQL_TIME *dt,
                                date_conv_mode_t fuzzydate);

inline void datetime_to_date(MYSQL_TIME *ltime)
{
  DBUG_ASSERT(ltime->time_type == MYSQL_TIMESTAMP_DATE ||
              ltime->time_type == MYSQL_TIMESTAMP_DATETIME);
  DBUG_ASSERT(ltime->neg == 0);
  ltime->second_part= ltime->hour= ltime->minute= ltime->second= 0;
  ltime->time_type= MYSQL_TIMESTAMP_DATE;
}
inline void date_to_datetime(MYSQL_TIME *ltime)
{
  DBUG_ASSERT(ltime->time_type == MYSQL_TIMESTAMP_DATE ||
              ltime->time_type == MYSQL_TIMESTAMP_DATETIME);
  DBUG_ASSERT(ltime->neg == 0);
  ltime->time_type= MYSQL_TIMESTAMP_DATETIME;
}
void make_truncated_value_warning(THD *thd,
                                  Sql_condition::enum_warning_level level,
                                  const ErrConv *str_val,
                                  timestamp_type time_type,
                                  const char *db_name, const char *table_name,
                                  const char *field_name);

extern DATE_TIME_FORMAT *date_time_format_make(timestamp_type format_type,
					       const char *format_str,
					       uint format_length);
extern DATE_TIME_FORMAT *date_time_format_copy(THD *thd,
					       DATE_TIME_FORMAT *format);
const char *get_date_time_format_str(KNOWN_DATE_TIME_FORMAT *format,
				     timestamp_type type);
bool my_TIME_to_str(const MYSQL_TIME *ltime, String *str, uint dec);

/* MYSQL_TIME operations */
bool date_add_interval(THD *thd, MYSQL_TIME *ltime, interval_type int_type,
                       const INTERVAL &interval, bool push_warn= true);
bool calc_time_diff(const MYSQL_TIME *l_time1, const MYSQL_TIME *l_time2,
                    int l_sign, ulonglong *seconds_out, ulong *microseconds_out);
int append_interval(String *str, interval_type int_type,
                    const INTERVAL &interval);
/**
  Calculate time difference between two MYSQL_TIME values and
  store the result as an out MYSQL_TIME value in MYSQL_TIMESTAMP_TIME format.

The result can be outside of the supported TIME range.
  For example, calc_time_diff('2002-01-01 00:00:00', '2001-01-01 00:00:00')
  returns '8760:00:00'. So the caller might want to do check_time_range() or
  adjust_time_range_with_warn() on the result of a calc_time_diff() call.

@param l_time1       - the minuend (TIME/DATE/DATETIME value)
  @param l_time2       - the subtrahend TIME/DATE/DATETIME value
  @param l_sign        -  +1 if absolute values are to be subtracted,
                          or -1 if absolute values are to be added.
  @param[out] l_time3  - the result
  @param fuzzydate     - flags

@return true         - if TIME_NO_ZERO_DATE was passed in flags and
                         the result appeared to be '00:00:00.000000'.
                         This is important when calc_time_diff() is called
                         when calculating DATE_ADD(TIMEDIFF(...),...)
  @return false        - otherwise
*/
bool calc_time_diff(const MYSQL_TIME *l_time1, const MYSQL_TIME *l_time2,
                    int lsign, MYSQL_TIME *l_time3, date_mode_t fuzzydate);
int my_time_compare(const MYSQL_TIME *a, const MYSQL_TIME *b);
void localtime_to_TIME(MYSQL_TIME *to, struct tm *from);

void calc_time_from_sec(MYSQL_TIME *to, ulong seconds, ulong microseconds);
uint calc_week(const MYSQL_TIME *l_time, uint week_behaviour, uint *year);

int calc_weekday(long daynr,bool sunday_first_day_of_week);
bool parse_date_time_format(timestamp_type format_type, 
                            const char *format, uint format_length,
                            DATE_TIME_FORMAT *date_time_format);

/* convenience wrapper */
inline bool parse_date_time_format(timestamp_type format_type, 
                                   DATE_TIME_FORMAT *date_time_format)
{
  return parse_date_time_format(format_type,
                                date_time_format->format.str,
                                (uint) date_time_format->format.length,
                                date_time_format);
}

extern DATE_TIME_FORMAT global_date_format;
extern DATE_TIME_FORMAT global_datetime_format;
extern DATE_TIME_FORMAT global_time_format;
extern KNOWN_DATE_TIME_FORMAT known_date_time_formats[];
extern LEX_CSTRING interval_type_to_name[];

static inline bool
non_zero_hhmmssuu(const MYSQL_TIME *ltime)
{
  return ltime->hour || ltime->minute || ltime->second || ltime->second_part;
}
static inline bool
non_zero_YYMMDD(const MYSQL_TIME *ltime)
{
  return ltime->year || ltime->month || ltime->day;
}
static inline bool
non_zero_date(const MYSQL_TIME *ltime)
{
  return non_zero_YYMMDD(ltime) ||
         (ltime->time_type == MYSQL_TIMESTAMP_DATETIME &&
          non_zero_hhmmssuu(ltime));
}
static inline bool
check_date(const MYSQL_TIME *ltime, date_conv_mode_t flags, int *was_cut)
{
 return check_date(ltime, non_zero_date(ltime),
                   ulonglong(flags & TIME_MODE_FOR_XXX_TO_DATE), was_cut);
}
bool check_date_with_warn(THD *thd, const MYSQL_TIME *ltime,
                          date_conv_mode_t fuzzy_date, timestamp_type ts_type);
static inline bool
check_date_with_warn(THD *thd, const MYSQL_TIME *ltime,
                          date_mode_t fuzzydate, timestamp_type ts_type)
{
  return check_date_with_warn(thd, ltime, date_conv_mode_t(fuzzydate), ts_type);
}

bool adjust_time_range_with_warn(THD *thd, MYSQL_TIME *ltime, uint dec);

longlong pack_time(const MYSQL_TIME *my_time);
void unpack_time(longlong packed, MYSQL_TIME *my_time,
                 enum_mysql_timestamp_type ts_type);

#endif /* SQL_TIME_INCLUDED */

Name	Type	Actions
atomic	Directory
aligned.h	File
aria_backup.h	File
assume_aligned.h	File
authors.h	File
backup.h	File
bounded_queue.h	File
client_settings.h	File
compat56.h	File
config.h	File
contributors.h	File
create_options.h	File
create_tmp_table.h	File
cset_narrowing.h	File
custom_conf.h	File
datadict.h	File
ddl_log.h	File
debug.h	File
debug_sync.h	File
derived_handler.h	File
derror.h	File
des_key_file.h	File
discover.h	File
dur_prop.h	File
embedded_priv.h	File
event_data_objects.h	File
event_db_repository.h	File
event_parse_data.h	File
event_queue.h	File
event_scheduler.h	File
events.h	File
field.h	File
field_comp.h	File
filesort.h	File
filesort_utils.h	File
ft_global.h	File
gcalc_slicescan.h	File
gcalc_tools.h	File
grant.h	File
group_by_handler.h	File
gstream.h	File
ha_handler_stats.h	File
ha_partition.h	File
ha_sequence.h	File
handle_connections_win.h	File
handler.h	File
hash.h	File
hash_filo.h	File
heap.h	File
hostname.h	File
ilist.h	File
init.h	File
innodb_priv.h	File
item.h	File
item_cmpfunc.h	File
item_create.h	File
item_func.h	File
item_geofunc.h	File
item_jsonfunc.h	File
item_row.h	File
item_strfunc.h	File
item_subselect.h	File
item_sum.h	File
item_timefunc.h	File
item_vers.h	File
item_windowfunc.h	File
item_xmlfunc.h	File
json_table.h	File
key.h	File
keycaches.h	File
lex.h	File
lex_string.h	File
lex_symbol.h	File
lf.h	File
lock.h	File
log.h	File
log_event.h	File
log_event_data_type.h	File
log_event_old.h	File
log_slow.h	File
maria.h	File
mariadb.h	File
mdl.h	File
mem_root_array.h	File
message.h	File
multi_range_read.h	File
my_alarm.h	File
my_apc.h	File
my_atomic.h	File
my_atomic_wrapper.h	File
my_base.h	File
my_bit.h	File
my_bitmap.h	File
my_check_opt.h	File
my_compare.h	File
my_counter.h	File
my_cpu.h	File
my_crypt.h	File
my_decimal.h	File
my_default.h	File
my_handler_errors.h	File
my_json_writer.h	File
my_libwrap.h	File
my_md5.h	File
my_minidump.h	File
my_nosys.h	File
my_rdtsc.h	File
my_rnd.h	File
my_service_manager.h	File
my_stack_alloc.h	File
my_stacktrace.h	File
my_time.h	File
my_tree.h	File
my_uctype.h	File
my_user.h	File
myisam.h	File
myisamchk.h	File
myisammrg.h	File
myisampack.h	File
mysqld.h	File
mysqld_default_groups.h	File
mysqld_suffix.h	File
mysys_err.h	File
opt_range.h	File
opt_subselect.h	File
opt_trace.h	File
opt_trace_context.h	File
parse_file.h	File
partition_element.h	File
partition_info.h	File
password.h	File
pfs_file_provider.h	File
pfs_idle_provider.h	File
pfs_memory_provider.h	File
pfs_metadata_provider.h	File
pfs_socket_provider.h	File
pfs_stage_provider.h	File
pfs_statement_provider.h	File
pfs_table_provider.h	File
pfs_thread_provider.h	File
pfs_transaction_provider.h	File
privilege.h	File
probes_mysql.h	File
probes_mysql_dtrace.h	File
probes_mysql_nodtrace.h	File
procedure.h	File
protocol.h	File
proxy_protocol.h	File
queues.h	File
records.h	File
repl_failsafe.h	File
replication.h	File
rijndael.h	File
rowid_filter.h	File
rpl_constants.h	File
rpl_filter.h	File
rpl_gtid.h	File
rpl_injector.h	File
rpl_mi.h	File
rpl_parallel.h	File
rpl_record.h	File
rpl_record_old.h	File
rpl_reporting.h	File
rpl_rli.h	File
rpl_tblmap.h	File
rpl_utility.h	File
scheduler.h	File
scope.h	File
select_handler.h	File
semisync.h	File
semisync_master.h	File
semisync_master_ack_receiver.h	File
semisync_slave.h	File
service_versions.h	File
session_tracker.h	File
set_var.h	File
slave.h	File
socketpair.h	File
source_revision.h	File
sp.h	File
sp_cache.h	File
sp_head.h	File
sp_pcontext.h	File
sp_rcontext.h	File
span.h	File
spatial.h	File
sql_acl.h	File
sql_admin.h	File
sql_alloc.h	File
sql_alter.h	File
sql_analyse.h	File
sql_analyze_stmt.h	File
sql_array.h	File
sql_audit.h	File
sql_base.h	File
sql_basic_types.h	File
sql_binlog.h	File
sql_bitmap.h	File
sql_bootstrap.h	File
sql_cache.h	File
sql_callback.h	File
sql_class.h	File
sql_cmd.h	File
sql_connect.h	File
sql_const.h	File
sql_crypt.h	File
sql_cte.h	File
sql_cursor.h	File
sql_db.h	File
sql_debug.h	File
sql_delete.h	File
sql_derived.h	File
sql_digest.h	File
sql_digest_stream.h	File
sql_do.h	File
sql_error.h	File
sql_explain.h	File
sql_expression_cache.h	File
sql_get_diagnostics.h	File
sql_handler.h	File
sql_help.h	File
sql_hset.h	File
sql_i_s.h	File
sql_insert.h	File
sql_join_cache.h	File
sql_lex.h	File
sql_lifo_buffer.h	File
sql_limit.h	File
sql_list.h	File
sql_load.h	File
sql_locale.h	File
sql_manager.h	File
sql_mode.h	File
sql_parse.h	File
sql_partition.h	File
sql_partition_admin.h	File
sql_plist.h	File
sql_plugin.h	File
sql_plugin_compat.h	File
sql_prepare.h	File
sql_priv.h	File
sql_profile.h	File
sql_reload.h	File
sql_rename.h	File
sql_repl.h	File
sql_schema.h	File
sql_select.h	File
sql_sequence.h	File
sql_servers.h	File
sql_show.h	File
sql_signal.h	File
sql_sort.h	File
sql_statistics.h	File
sql_string.h	File
sql_table.h	File
sql_tablespace.h	File
sql_test.h	File
sql_time.h	File
sql_trigger.h	File
sql_truncate.h	File
sql_tvc.h	File
sql_type.h	File
sql_type_fixedbin.h	File
sql_type_fixedbin_storage.h	File
sql_type_geom.h	File
sql_type_int.h	File
sql_type_json.h	File
sql_type_real.h	File
sql_type_string.h	File
sql_udf.h	File
sql_union.h	File
sql_update.h	File
sql_view.h	File
sql_window.h	File
ssl_compat.h	File
strfunc.h	File
structs.h	File
sys_vars_shared.h	File
t_ctype.h	File
table.h	File
table_cache.h	File
thr_alarm.h	File
thr_lock.h	File
thr_malloc.h	File
thr_timer.h	File
thread_cache.h	File
threadpool.h	File
threadpool_generic.h	File
threadpool_winsockets.h	File
transaction.h	File
tzfile.h	File
tztime.h	File
uniques.h	File
unireg.h	File
vers_string.h	File
violite.h	File
waiting_threads.h	File
welcome_copyright_notice.h	File
win_tzname_data.h	File
winservice.h	File
wqueue.h	File
wsrep.h	File
wsrep_applier.h	File
wsrep_binlog.h	File
wsrep_client_service.h	File
wsrep_client_state.h	File
wsrep_condition_variable.h	File
wsrep_high_priority_service.h	File
wsrep_mutex.h	File
wsrep_mysqld.h	File
wsrep_mysqld_c.h	File
wsrep_on.h	File
wsrep_priv.h	File
wsrep_schema.h	File
wsrep_server_service.h	File
wsrep_server_state.h	File
wsrep_sst.h	File
wsrep_storage_service.h	File
wsrep_thd.h	File
wsrep_trans_observer.h	File
wsrep_types.h	File
wsrep_utils.h	File
wsrep_var.h	File
wsrep_xid.h	File
xa.h	File