Hello
try
CREATE OR REPLACE FUNCTION public.fdow(date)
RETURNS date
LANGUAGE sql
IMMUTABLE STRICT
AS $function$ select $1 - extract(dow from $1)::int $function$
postgres=# select fdow(current_date);
fdow
------------
2008-10-26
(1 row)
regards
Pavel Stehule
2008/10/29 x asasaxax <[EMAIL PROTECTED]>:
> Hi,
>
> I need a function to select the first day of the week. For example
> giving today´s date(29/10/2008).
>
> Can anyone help´s me?
> Thanks!
>
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
