Re: [SQL] Extract week from date, start with sunday

2011-10-11 Thread skdangi
You can use the below query to get the week from Sunday. select ceil(((now()::date -((CAST(EXTRACT (year FROM now()) as text)||'-01-04')::date - CAST (EXTRACT (isodow FROM (CAST(EXTRACT (year FROM now()) as text)||'-01-04')::date)

[SQL]

2011-10-11 Thread Theodore Petrosky
...This site has almost all you need! http://avto-partner.si/com.friend.php?oshowtopic=48n9 -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql