There is no such function built in. Its why people also redundantly store temporal values with the proper granularity. Then this cost is at least be carried once /tuple. regards, Martin On 8/13/13 6:20 PM, Ravikumar Balasubramaniam wrote:
Hi,
I'm trying to truncate timestamp value to hour and/or minute precision. I combined cast and extract functions as:
Problem: Truncate '2013-08-12 23:59:59' to '2013-08-12 23:00:00'
select cast(timestamp '2013-08-12 23:59:59' as date)||' '||extract(hour from timestamp '2013-08-12 23:59:59')||':00:00'; Output: 2013-08-12 23:00:00
But this is expensive because of repeated function calls. Is there any faster and built-in function?
Regards, Ravi
_______________________________________________ users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list