If diff_time is an interval day to minute, extract(day from diff_time) will work.
Recent Threads
Attachments
Library
Quick Reference
Useful Links
Rules of Conduct
FAQs
Join the Forum
Archives
Sample Index
2002 Indexes