picoSQL - Language reference manual
picoSQL - Language reference manual |
|
The arguments of the following function must be of DATE type, TIME type or TIMESTAMP type.
String expression are not allowed as arguments while escape sequences are allowed.
|
DAYOFMONTH(timestamp) |
Returns a number from 1 to 31 corresponding to the month of the given timestamp.
|
|
HOUR(timestamp) |
Returns a number from 0 to 23 corresponding to the hour of the given timestamp.
|
|
MILLISECOND(timestamp) |
Returns a number from 0 to 999 corresponding to the milliseconds of the given timestamp.
|
|
MINUTE(timestamp) |
Returns a number from 0 to 59 corresponding to the minute of the given timestamp.
|
|
MONTH(timestamp) |
Returns a number from 1 to 12 corresponding to the month of the given timestamp.
|
|
NOW( ) |
Returns a timestamp with the current date and time.
|
|
SECOND(timestamp) |
Returns a number from 0 to 59 corresponding to the seconds of the given timestamp.
|
|
YEAR(timestamp) |
Returns a number from 1 to 9999 corresponding to the year of the given timestamp.
|