cop_trunc_date() formats

Variables
static final String	org.qore.lang.sqlutil.AbstractTable.DT_YEAR = "Y"
	Format unit: year.
static final String	org.qore.lang.sqlutil.AbstractTable.DT_MONTH = "M"
	Format unit: month.
static final String	org.qore.lang.sqlutil.AbstractTable.DT_DAY = "D"
	Format unit: day.
static final String	org.qore.lang.sqlutil.AbstractTable.DT_HOUR = "H"
	Format unit: hour.
static final String	org.qore.lang.sqlutil.AbstractTable.DT_MINUTE = "m"
	Format unit: minute.
static final String	org.qore.lang.sqlutil.AbstractTable.DT_SECOND = "S"
	Format unit: hour.

Detailed Description

These are formatting constant which can be used as cop_trunc_date() formatting arguments.

Input date used in the table below: 2017-04-20 14:27:34

|!Constant|!Meaning|!Example |DT_YEAR|Truncate date up to year|2017-01-01 00:00:00 |DT_MONTH|Truncate date up to month|2017-04-01 00:00:00 |DT_DAY|Truncate date up to day|2017-01-20 00:00:00 |DT_HOUR|Truncate date up to hour|2017-01-20 14:00:00 |DT_MINUTE|Truncate date up to minute|2017-01-20 14:27:00 |DT_SECOND|Truncate date up to second|2017-01-20 14:27:34

Note

Oracle: using DT_SECOND for DATE type does not make sense as the DATE resolution is up to seconds out of the box. On the other side TINESTAMP is truncated up to seconds with this operator.