PL/SQL: epoch to date

SELECT TO_CHAR(TO_DATE('19700101','YYYYMMDD') + (1364986608/(60*60*24)),'DD:MM:YYYY HH24:MI:SS') my_date FROM dual;

Git: How to retrieve a single file from specific revision?

> git show $REV:$FILE

E.g.

> git show 4b286e8:./src/com/mobiquithings/gprstrial/ConnectivityService.java

NB: use a ./ syntax or an absolute path

PL / SQL UPDATE + JOIN

MERGE INTO T1
USING T2
ON (T1.PK = T2.PK)
WHEN MATCHED THEN 
UPDATE SET T1.VAL = T2.VAL;

Exit AirDroid

Disconnect, then press Back, and the application will ask if you want to exit