tinoest

Database => PostgreSQL => Topic started by: tino on February 26, 2017, 06:50:11 pm

Title: timestamp round function
Post by: tino on February 26, 2017, 06:50:11 pm
Code: [Select]
CREATE FUNCTION ts_round( timestamptz, INT4 ) RETURNS TIMESTAMPTZ AS $$
    SELECT 'epoch'::timestamptz + '1 second'::INTERVAL * ( $2 * ( extract( epoch FROM $1 )::INT4 / $2 ) );
$$ LANGUAGE SQL;