select dateadd(minute, datediff(minute,0,GETDATE()) / 15 * 15, 0). GETDATE() is whatever your datetime is. This will work for dates at least up to the year ...
確定! 回上一頁