-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 02/14/07 02:52, A. Kretschmer wrote: > am Tue, dem 13.02.2007, um 13:56:15 -0800 mailte vanessa folgendes: [snip] > > test=*# select get_week(2007,2); > get_week > ------------------------- > 08-01-2007 - 14-01-2007 > (1 row) Is that week #2? If weeks start on Sunday (which is what they do in the US), then week #2 would either start on 04-Jan or 11-Jan (depending on whether the 01-Jan partial week is considered week #1 or week #0). -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFF0tH5S9HxQb37XmcRAkcwAJkBy2zGzsOoHQYMWpQyy/gWkFMrYwCgvSPh 62eczkEjSH9hf/CqCmHLBzQ= =bhxF -----END PGP SIGNATURE-----