I'd do like this, first create a view for your table that returns all columns but the timestamp column. Instead you add a column with a modifed timestamp, which you use when comparing timestamps.
Something like:
CREATE VIEW v1 AS
SELECT c1,
...,
SUBSTRING(CAST(ts AS CHAR(40)) FROM 11 FOR 14) ||
CAST(EXTRACT(MINUTE FROM ts)/15 AS CHAR(1)) AS ts FROM tab;
ts above is the timestamp column.
Note that you may have to modify the SUBSTRING values. In my example I expect the SQL standard's timstamp format:
TIMESTAMP'2004-05-14 14:20:05.930000'
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.