Please use the links in the table below to view the eXtremeSQL date and time functions:
day(<epoch_time>) Returns the day component of the time represented as the number of seconds elapsed since January 1, 1970 dmy(<day>, <month>, <year>) Returns the integer representation of date YYYYMMDD (<year>*10000 + <month>*100 + <day>) date2str(<int_date>) Converts integer date representation YYYYMMDD to string 'DD.MM.YYYY' get_day(<int_date>) Returns the day component from the integer representation of the date (YYYYMMDD) get_month(<int_date>) Returns the month component from the integer representation of the date (YYYYMMDD) get_year(<int_date>) Returns the year component from the integer representation of the date (YYYYMMDD) hour(<epoch_time>) Returns the hour component (0-23) of the time represented as the number of seconds elapsed since the January 1, 1970 month(<epoch_time>) Returns the month component of the time represented as the number of seconds elapsed since the January 1, 1970 now Returns the current EPOCH time (the number of seconds elapsed since January 1, 1970) second(<epoch_time>) Returns the seconds component (0-59) of the time represented as the number of seconds elapsed since the January 1, 1970 str2date(<str_date>) Converts the string representation of the date ('dd.mm.yyyy', 'mm/dd/yyyy' or 'dd-MON-yyyy') to the integer representation YYYYMMDD (year*10000 + month*100 + day) sysdate() Returns the current EPOCH time (the number of seconds elapsed since January 1, 1970) week_day(<epoch_time>) Returns the day of the week (Sunday is 0, Saturday is 6) component of the time represented as the number of seconds elapsed since the January 1, 1970 year(<epoch_time>) Returns the year component of the time represented as the number of seconds elapsed since the January 1, 1970 setDateTimePrecision() Change the precision for DateTime operations using eXtremeSQL