net.ymate.platform.persistence.jdbc.query

Interface Func.DateTime

All Known Implementing Classes:

QueryBuilder

Enclosing interface:

Func

public static interface Func.DateTime

Date and Time Functions

Method Summary

Modifier and Type	Method and Description
default IFunction	ADDDATE(IFunction expr, Number days)
default IFunction	ADDDATE(String expr, Number days)
default IFunction	ADDTIME(IFunction expr, IFunction expr2)
default IFunction	ADDTIME(String expr, String expr2)
default IFunction	CONVERT_TZ(IFunction dt, String fromTz, String toTz)
default IFunction	CONVERT_TZ(String dt, String fromTz, String toTz)
default IFunction	CURDATE()
default IFunction	CURTIME()
default IFunction	DATE_FORMAT(IFunction date, String format)
default IFunction	DATE_FORMAT(String date, String format)
default IFunction	DATE(IFunction expr)
default IFunction	DATE(String expr)
default IFunction	DATEDIFF(IFunction expr, IFunction expr2)
default IFunction	DATEDIFF(String expr, String expr2)
default IFunction	DAYNAME(IFunction date)
default IFunction	DAYNAME(String date)
default IFunction	DAYOFMONTH(IFunction date)
default IFunction	DAYOFMONTH(String date)
default IFunction	DAYOFWEEK(IFunction date)
default IFunction	DAYOFWEEK(String date)
default IFunction	DAYOFYEAR(IFunction date)
default IFunction	DAYOFYEAR(String date)
default IFunction	FROM_UNIXTIME(IFunction timestamp)
default IFunction	FROM_UNIXTIME(IFunction timestamp, String format)
default IFunction	FROM_UNIXTIME(String timestamp)
default IFunction	FROM_UNIXTIME(String timestamp, String format)
default IFunction	GET_FORMAT(IFunction date, String type)
default IFunction	GET_FORMAT(String date, String type)
default IFunction	HOUR(IFunction time)
default IFunction	HOUR(String time)
default IFunction	LAST_DAY(IFunction date)
default IFunction	LAST_DAY(String date)
default IFunction	MAKEDATE(IFunction year, IFunction dayOfYear)
default IFunction	MAKEDATE(String year, String dayOfYear)
default IFunction	MAKETIME(IFunction hour, IFunction minute, IFunction second)
default IFunction	MAKETIME(String hour, String minute, String second)
default IFunction	MICROSECOND(IFunction expr)
default IFunction	MICROSECOND(String expr)
default IFunction	MINUTE(IFunction time)
default IFunction	MINUTE(String time)
default IFunction	MONTH(IFunction date)
default IFunction	MONTH(String date)
default IFunction	MONTHNAME(IFunction date)
default IFunction	MONTHNAME(String date)
default IFunction	NOW()
default IFunction	PERIOD_ADD(IFunction p, IFunction n)
default IFunction	PERIOD_ADD(String p, String n)
default IFunction	PERIOD_DIFF(IFunction p1, IFunction p2)
default IFunction	PERIOD_DIFF(String p1, String p2)
default IFunction	QUARTER(IFunction date)
default IFunction	QUARTER(String date)
default IFunction	SEC_TO_TIME(IFunction seconds)
default IFunction	SEC_TO_TIME(String seconds)
default IFunction	SECOND(IFunction date)
default IFunction	SECOND(String date)
default IFunction	STR_TO_DATE(IFunction str, String format)
default IFunction	STR_TO_DATE(String str, String format)
default IFunction	SYSDATE()
default IFunction	TIME_FORMAT(IFunction time, String format)
default IFunction	TIME_FORMAT(String time, String format)
default IFunction	TIME_TO_SEC(IFunction time)
default IFunction	TIME_TO_SEC(String time)
default IFunction	TIME(IFunction expr)
default IFunction	TIME(String expr)
default IFunction	TIMEDIFF(IFunction expr, IFunction expr2)
default IFunction	TIMEDIFF(String expr, String expr2)
default IFunction	TIMESTAMP(IFunction expr)
default IFunction	TIMESTAMP(IFunction expr, IFunction expr2)
default IFunction	TIMESTAMP(String expr)
default IFunction	TIMESTAMP(String expr, String expr2)
default IFunction	TIMESTAMPDIFF(String unit, IFunction datetimeExpr1, IFunction datetimeExpr2)
default IFunction	TIMESTAMPDIFF(String unit, String datetimeExpr1, String datetimeExpr2)
default IFunction	TO_DAYS(IFunction date)
default IFunction	TO_DAYS(String date)
default IFunction	UNIX_TIMESTAMP()
default IFunction	UNIX_TIMESTAMP(IFunction date)
default IFunction	UNIX_TIMESTAMP(String date)
default IFunction	UTC_DATE()
default IFunction	UTC_TIME()
default IFunction	UTC_TIMESTAMP()
default IFunction	WEEK(IFunction date)
default IFunction	WEEK(IFunction date, Number mode)
default IFunction	WEEK(String date)
default IFunction	WEEK(String date, Number mode)
default IFunction	WEEKDAY(IFunction date)
default IFunction	WEEKDAY(String date)
default IFunction	WEEKOFYEAR(IFunction date)
default IFunction	WEEKOFYEAR(String date)
default IFunction	YEAR(IFunction date)
default IFunction	YEAR(String date)
default IFunction	YEARWEEK(IFunction date)
default IFunction	YEARWEEK(IFunction date, Number mode)
default IFunction	YEARWEEK(String date)
default IFunction	YEARWEEK(String date, Number mode)

Method Detail

ADDDATE

default IFunction ADDDATE(String expr,
                          Number days)

ADDDATE

default IFunction ADDDATE(IFunction expr,
                          Number days)

ADDTIME

default IFunction ADDTIME(String expr,
                          String expr2)

ADDTIME

default IFunction ADDTIME(IFunction expr,
                          IFunction expr2)

CONVERT_TZ

default IFunction CONVERT_TZ(String dt,
                             String fromTz,
                             String toTz)

CONVERT_TZ

default IFunction CONVERT_TZ(IFunction dt,
                             String fromTz,
                             String toTz)

CURDATE

default IFunction CURDATE()

CURTIME

default IFunction CURTIME()

DATE

default IFunction DATE(String expr)

DATE

default IFunction DATE(IFunction expr)

DATE_FORMAT

default IFunction DATE_FORMAT(String date,
                              String format)

DATE_FORMAT

default IFunction DATE_FORMAT(IFunction date,
                              String format)

DATEDIFF

default IFunction DATEDIFF(String expr,
                           String expr2)

DATEDIFF

default IFunction DATEDIFF(IFunction expr,
                           IFunction expr2)

DAYNAME

default IFunction DAYNAME(String date)

DAYNAME

default IFunction DAYNAME(IFunction date)

DAYOFMONTH

default IFunction DAYOFMONTH(String date)

DAYOFMONTH

default IFunction DAYOFMONTH(IFunction date)

DAYOFWEEK

default IFunction DAYOFWEEK(String date)

DAYOFWEEK

default IFunction DAYOFWEEK(IFunction date)

DAYOFYEAR

default IFunction DAYOFYEAR(String date)

DAYOFYEAR

default IFunction DAYOFYEAR(IFunction date)

FROM_UNIXTIME

default IFunction FROM_UNIXTIME(String timestamp)

FROM_UNIXTIME

default IFunction FROM_UNIXTIME(IFunction timestamp)

FROM_UNIXTIME

default IFunction FROM_UNIXTIME(String timestamp,
                                String format)

FROM_UNIXTIME

default IFunction FROM_UNIXTIME(IFunction timestamp,
                                String format)

UNIX_TIMESTAMP

default IFunction UNIX_TIMESTAMP()

UNIX_TIMESTAMP

default IFunction UNIX_TIMESTAMP(String date)

UNIX_TIMESTAMP

default IFunction UNIX_TIMESTAMP(IFunction date)

GET_FORMAT

default IFunction GET_FORMAT(String date,
                             String type)

GET_FORMAT

default IFunction GET_FORMAT(IFunction date,
                             String type)

HOUR

default IFunction HOUR(String time)

HOUR

default IFunction HOUR(IFunction time)

LAST_DAY

default IFunction LAST_DAY(String date)

LAST_DAY

default IFunction LAST_DAY(IFunction date)

MAKEDATE

default IFunction MAKEDATE(String year,
                           String dayOfYear)

MAKEDATE

default IFunction MAKEDATE(IFunction year,
                           IFunction dayOfYear)

MAKETIME

default IFunction MAKETIME(String hour,
                           String minute,
                           String second)

MAKETIME

default IFunction MAKETIME(IFunction hour,
                           IFunction minute,
                           IFunction second)

MICROSECOND

default IFunction MICROSECOND(String expr)

MICROSECOND

default IFunction MICROSECOND(IFunction expr)

MINUTE

default IFunction MINUTE(String time)

MINUTE

default IFunction MINUTE(IFunction time)

MONTH

default IFunction MONTH(String date)

MONTH

default IFunction MONTH(IFunction date)

MONTHNAME

default IFunction MONTHNAME(String date)

MONTHNAME

default IFunction MONTHNAME(IFunction date)

NOW

default IFunction NOW()

PERIOD_ADD

default IFunction PERIOD_ADD(String p,
                             String n)

PERIOD_ADD

default IFunction PERIOD_ADD(IFunction p,
                             IFunction n)

PERIOD_DIFF

default IFunction PERIOD_DIFF(String p1,
                              String p2)

PERIOD_DIFF

default IFunction PERIOD_DIFF(IFunction p1,
                              IFunction p2)

QUARTER

default IFunction QUARTER(String date)

QUARTER

default IFunction QUARTER(IFunction date)

SEC_TO_TIME

default IFunction SEC_TO_TIME(String seconds)

SEC_TO_TIME

default IFunction SEC_TO_TIME(IFunction seconds)

SECOND

default IFunction SECOND(String date)

SECOND

default IFunction SECOND(IFunction date)

STR_TO_DATE

default IFunction STR_TO_DATE(String str,
                              String format)

STR_TO_DATE

default IFunction STR_TO_DATE(IFunction str,
                              String format)

SYSDATE

default IFunction SYSDATE()

TIME

default IFunction TIME(String expr)

TIME

default IFunction TIME(IFunction expr)

TIME_FORMAT

default IFunction TIME_FORMAT(String time,
                              String format)

TIME_FORMAT

default IFunction TIME_FORMAT(IFunction time,
                              String format)

TIME_TO_SEC

default IFunction TIME_TO_SEC(String time)

TIME_TO_SEC

default IFunction TIME_TO_SEC(IFunction time)

TIMEDIFF

default IFunction TIMEDIFF(String expr,
                           String expr2)

TIMEDIFF

default IFunction TIMEDIFF(IFunction expr,
                           IFunction expr2)

TIMESTAMP

default IFunction TIMESTAMP(String expr)

TIMESTAMP

default IFunction TIMESTAMP(IFunction expr)

TIMESTAMP

default IFunction TIMESTAMP(String expr,
                            String expr2)

TIMESTAMP

default IFunction TIMESTAMP(IFunction expr,
                            IFunction expr2)

TIMESTAMPDIFF

default IFunction TIMESTAMPDIFF(String unit,
                                String datetimeExpr1,
                                String datetimeExpr2)

TIMESTAMPDIFF

default IFunction TIMESTAMPDIFF(String unit,
                                IFunction datetimeExpr1,
                                IFunction datetimeExpr2)

TO_DAYS

default IFunction TO_DAYS(String date)

TO_DAYS

default IFunction TO_DAYS(IFunction date)

UTC_DATE

default IFunction UTC_DATE()

UTC_TIME

default IFunction UTC_TIME()

UTC_TIMESTAMP

default IFunction UTC_TIMESTAMP()

WEEK

default IFunction WEEK(String date)

WEEK

default IFunction WEEK(IFunction date)

WEEK

default IFunction WEEK(String date,
                       Number mode)

WEEK

default IFunction WEEK(IFunction date,
                       Number mode)

WEEKDAY

default IFunction WEEKDAY(String date)

WEEKDAY

default IFunction WEEKDAY(IFunction date)

WEEKOFYEAR

default IFunction WEEKOFYEAR(String date)

WEEKOFYEAR

default IFunction WEEKOFYEAR(IFunction date)

YEAR

default IFunction YEAR(String date)

YEAR

default IFunction YEAR(IFunction date)

YEARWEEK

default IFunction YEARWEEK(String date)

YEARWEEK

default IFunction YEARWEEK(IFunction date)

YEARWEEK

default IFunction YEARWEEK(String date,
                           Number mode)

YEARWEEK

default IFunction YEARWEEK(IFunction date,
                           Number mode)