Monthly Archives: December 2013

1433 commits or: gitshots 2013

31-Dec-13

While my project is full of pictures, this blog lacks some images and stuff… So for the last post in 2013 and the last commit being from the night before, i’ll add some fun content, a time-lapse of 1433 gitshots since July, 21st. Gitshot? What the heck is a git shot? This post-commit hook: #!/usr/bin/env […]

Read the complete article »

SQL Snippets

19-Dec-13

Some useful SQL Snippets: Oracle Create a date without any formatting hassle (like to_date): SELECT DATE’2014-01-01′ FROM dual; Extract values as numbers from a date object SELECT EXTRACT (YEAR FROM DATE’2013-05-06’) FROM dual; SELECT EXTRACT (MONTH FROM DATE’2013-05-06’) FROM dual; SELECT EXTRACT (DAY FROM DATE’2013-05-06’) FROM dual; Conversion of geographical coordinates into different coordinate systems: […]

Read the complete article »