Thursday, April 23, 2009

Oracle setting timestamp format and query

alter session set NLS_DATE_FORMAT='DD-MM-YYYY HH24:MI:SS'

select * from table where date > to_date('2009-04-01','yyyy-mm-dd');

Saturday, April 11, 2009

Problems with macbook

I started having this problem with my macbook and apparently I am not the only one
MacBook Crack

How to run a process even when your session ends and exits

Process :
-run process (from zshell)

-Ctrl-Z (to suspend)


-kill -CONT

Sunday, April 05, 2009

WalkScore of a Place

Get Walkscore of your place is a pretty handy tool to find out how accessible is your place to the nearby restaurants, gorceries, banks etc.