2008-10-01から1日間の記事一覧

postgresqlでfirst_day()関数

◆ first_day DROP FUNCTION first_day( DATE ); CREATE FUNCTION first_day( DATE ) RETURNS DATE AS 'select cast(date_trunc(''month'', $1) as date)' LANGUAGE 'sql'; ◆ last_day DROP FUNCTION last_day( DATE ); CREATE FUNCTION last_day( DATE ) RET…