A week ago I was contacted by Packt Publishing to review their new book Learning Ext JS. Having worked with Ext JS a few times (Mainly whilst helping develop Fork CMS), I’ve only scraped the surface of the possibilities so far and therefore am looking forward to receiving the book in my mailbox. In the …
Category Archives: Elsewhere
jQuery 1.3
Queries of the Lost Ark: timeBetween
Found these SQL snippets in a text file I was destined to lose. Hereby, for me to remember: [sql]# Difference between 2 timestamps (intial): TIMEDIFF(FROM_UNIXTIME(t.end_timestamp), FROM_UNIXTIME(t.start_timestamp)) AS timeBetweenInHours # Difference between 2 timestamps (better): SEC_TO_TIME(t.end_timestamp – t.start_timestamp) AS timeBetweenInHoursBetter # Difference between 2 timestamps in days: ROUND((SEC_TO_TIME(t.end_timestamp – t.start_timestamp) + 0) / 240000, 2) AS …