Brad Lucas

Programming, Clojure and other interests

Postgres Date Arithmetic

September 24, 2009

Postgres Date Arithmetic

Postgres Timestamp Addition

I created a table where I want to have two columns with dates. The first will be the date the record in the table is created. The other should be a week later. The table is for a contact management system where I'm going to keep information about when I emailed a contact and when I should follow up a week later.

In Postgres this turned out to be very easy. Look at the following table definition. You can easily create a date 7 days from now by adding "interval '7 days'" to now();


Continue reading →

Favicon

September 24, 2009

Just made a favicon.ico in a matter of minutes.

http://www.favicon.cc/


Continue reading →

Yqd – Yahoo Quote Downloader Reddit

September 23, 2009

Reddit

yqd - Yahoo Quote Downloader


Continue reading →

Yqd – Yahoo Quote Downloader Digg

September 23, 2009

Digg

yqd - Yahoo Quote Downloader


Continue reading →

Yqd – Yahoo Quote Downloader

September 22, 2009

Yqd is a command line tool for downloading historical price information from Yahoo. It accepts a group of symbols on the command line or from a file and downloads each symbols historical data to a CSV file. Yqd is useful for end of day scripts to download price information regularly.

More details...


Continue reading →