On 31/10/2007, Anton Andreev <anton.andreev@fmi.uni-sofia.bg> wrote:
> Hi,
>
> I have records with date column. Is there a way I can get which day of
> week this date is?
>
> Cheers,
> Anton
Hello
http://www.postgresql.org/docs/8.2/interactive/functions-datetime.html
EXTRACT or function date_part
Regards
Pavel Stehule
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
> choose an index scan if your joining column's datatypes do not
> match
>