SELECT (ARRAY['日','月','火','水','木','金','土'])[EXTRACT(DOW FROM CAST('2009-09-28 19:30' AS DATE)) + 1];