Returns a TIMESTAMP at the end of AHOUR:AMINUTE on the date AYEAR, AMONTH, ADAY, or at the end of the minute of ATIMESTAMP.
MINUTEEND(AYEAR INTEGER, AMONTH INTEGER, ADAY INTEGER, AHOUR INTEGER, AMINUTE INTEGER)
MINUTEEND(ATIMESTAMP TIMESTAMP)
MINUTEEND(ATIMESTAMP VARCHAR(26))
RETURNS TIMESTAMP
Returns a TIMESTAMP value representing the last microsecond of AMINUTE in AHOUR on the date given by AYEAR, AMONTH, and ADAY, or of the timestamp given by ATIMESTAMP depending on the variant of the function that is called.
- AYEAR
If provided, the year component of the resulting timestamp.
- AMONTH
If provided, the month component of the resulting timestamp.
- ADAY
If provided, the day component of the resulting timestamp.
- AHOUR
If provided, the hour component of the resulting timestamp.
- AMINUTE
If provided, the minute component of the resulting timestamp.
- ATIMESTAMP
If provided, the timestamp from which to derive the end of the minute. Either AYEAR, AMONTH, ADAY, AHOUR, and AMINUTE, or ATIMESTAMP must be provided.
Round the specified timestamp up to one microsecond before the next minute:
VALUES MINUTEEND('2010-01-23 04:56:12');
1
--------------------------
2010-01-23-04.56.59.999999
Generate a timestamp at the end of a minute with the specified fields:
VALUES MINUTEEND(2010, 2, 14, 9, 30);
1
--------------------------
2010-02-14-09.30.59.999999
- Source code
MINUTE_START
- MINUTE (built-in function)