One Quickie


Time interval math to integer (Postgresql->General)
If you take the difference between two timestamps, you can end up with an unweildly value like "00:06:14.37086 days old". You can cast the timestamps into just regular dates like:
select current_timestamp()::date - entry_date::date as days_old from kb_nuggets;



borkware home | products | miniblog | rants | quickies | cocoaheads
Advanced Mac OS X Programming book

webmonster@borkware.com