Datetime arithmetic in sqlite
To find out the # of minutes since a datetime in a sqlite table (example column jobend), do the below: select jobend, cast(((julianday(current_timestamp)-julianday(jobend))*1440) as int) as mins_passed from job Credits
Archive of posts tagged sql
A day in the life of a slow page at Stack Overflow
A day in the life of a slow page at Stack Overflow.
How do large-scale sites and applications remain SQL-based?
Scalable SQL – ACM Queue.
PostgreSQL: Documentation: Manuals: PostgreSQL 9.0: Window Functions
A window function performs a calculation across a set of table rows that are somehow related to the current row. This is comparable to the type of calculation that can be done with an aggregate function. But unlike regular aggregate functions, use of a window function does not cause rows to become grouped into a …
Continue reading ‘PostgreSQL: Documentation: Manuals: PostgreSQL 9.0: Window Functions’ »