import datetime

today = datetime.date.today()
today.isocalendar()[1]

SELECT EXTRACT(WEEK FROM TIMESTAMP '2012-12-04 20:38:40');