Denis Zaitsev <[EMAIL PROTECTED]> writes: > How can I calculate the number of second in some interval? Neither > the secods part, nor the seconds after midnight... Just the full > quantity of the seconds. I haven't find any function.
EXTRACT(EPOCH FROM interval_value)
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
