Datum zacatku aktualniho tydne v PG

[Honza Pazdziora]

On Tue, Apr 06, 2004 at 12:36:10PM +0200, Ota Kleps wrote:
> 
> jak zjistit datum zacatku aktualniho tydne(jedno jestli na NE nebo PO) 
> primo v SQL - bez pomocnych funkci?
> 
> Lakalo by me pouzit neco takoveho(jasne, ze to nefunguje ;-):
> SELECT CURRENT_DATE-interval date_part('dow',CURRENT_DATE)||' days';

	- cast(date_part('dow', current_date) || ' days' as interval)

-- 
------------------------------------------------------------------------
 Honza Pazdziora | adelton na fi.muni.cz | http://www.fi.muni.cz/~adelton/
 .project: Perl, mod_perl, DBI, Oracle, large Web systems, XML/XSL, ...
		Only self-confident people can be simple.