# eXtremeSQL Date/Time Functions

> 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