Eric Yang eyanq

## postgres_util.sql
-- get last week first day and last week last day
SELECT
  (to_date(concat(EXTRACT(YEAR FROM CURRENT_DATE),EXTRACT(week FROM CURRENT_DATE - '1 week' :: INTERVAL)),'iyyyiw'))::text AS start_date,
  (to_date(concat(EXTRACT(YEAR FROM CURRENT_DATE),EXTRACT(week FROM CURRENT_DATE - '1 week' :: INTERVAL)),'iyyyiw') + 6)::text AS end_date
;

## helloworld.py
def hello():
  print "Hello, GistBox!"

## 0_reuse_code.js
// Use Gists to store code you would like to remember later on
console.log(window); // log the "window" object to the console
	-- get last week first day and last week last day
	SELECT
	(to_date(concat(EXTRACT(YEAR FROM CURRENT_DATE),EXTRACT(week FROM CURRENT_DATE - '1 week' :: INTERVAL)),'iyyyiw'))::text AS start_date,
	(to_date(concat(EXTRACT(YEAR FROM CURRENT_DATE),EXTRACT(week FROM CURRENT_DATE - '1 week' :: INTERVAL)),'iyyyiw') + 6)::text AS end_date
	;
	// Use Gists to store code you would like to remember later on
	console.log(window); // log the "window" object to the console