Database Reference
In-Depth Information
Table 11-1. Date and time intervals and formats
INTERVAL
Format for given values
dd
DAY
'dd hh'
DAY_HOUR
'dd.nn'
DAY_MICROSECOND
'dd hh:mm'
DAY_MINUTE
'dd hh:mm:ss'
DAY_SECOND
hh
HOUR
HOUR_MICROSECOND 'hh.nn'
'hh:mm'
HOUR_MINUTE
'hh:mm:ss'
HOUR_SECOND
nn
MICROSECOND
mm
MINUTE
MINUTE_MICROSECOND 'mm.nn'
'mm:ss'
MINUTE_SECOND
mm
MONTH
qq
QUARTER
ss
SECOND
SECOND_MICROSECOND 'ss.nn'
ww
WEEK
yy
YEAR
'yy-mm'
YEAR_MONTH
Search WWH ::




Custom Search