下面命令得到的是一个星期的第几天，the day of week（0~6， 0是Sunday） select extract(dow from now()); 如果想转成Monday或者Mon怎么办呢？下面这个从网上找来的函数就是来做这个转换的， CREATE OR REPLACE FUNCTION dayOfWeek (date Date) RETURNS Character Varying(15) AS $$ DECLARE DAY_OF_WEEK_CONST Character Varying(15) := ‘dow’; dayOfWeek Integer := 0; dayName Character Varying(15) := ‘Test’; BEGIN dayOfWeek := date_part(DAY_OF_WEEK_CONST, Date); IF dayOfWeek = 0 THEN dayName := ‘Sunday’; ELSEIF dayOfWeek = 1 THEN … Continue reading PostgreSQL 获得星期的名字