ROUND_TIMESTAMP(CURRENT TIMESTAMP,'MI'):
The ROUND_TIMESTAMP function returns a timestamp that is the expression rounded to the unit specified by the format-string. In this case, MI means minutes.
For example, the output of
SELECT ROUND_TIMESTAMP('2008-10-16-14.46.22.121222','MI')
FROM SYSIBM.SYSDUMMY1
looks like this:
2008-10-16-14.46.00.000000
No comments:
Post a Comment