On Tue, 15 Jan 2002 13:47 +0200, Bogdan Marinca wrote:
>
>
> Salut.
> Nu stiu daca e o problema adevarata sau gresesc eu undeva ...
> Cum se calculeaza nr de ordine al saptamanii intr`un an,
> al unei date(timestamp) anumite ?
Postgresql stie fie:
- week number of year (1-53) where first week start on the first day
of the year (WW)
- ISO week number of year (The first Thursday of the new year is in
week 1.) (IW)
> In this paper, the date/time 14 February 1993, 13:10:30 (ten minutes and thirty
>seconds past one pm) is used to
> demonstrate formats. The ordinal day number is 045 and the week number is 06. The
>day number within the week is 7.
> ''
>
> la mine ... :
>
> teste=# select to_char(date('14-Feb-1993'), 'WW');
> to_char
> ---------
> 07
> (1 row)
>
> deci nu 06 cum trebuia ...
>
> unde ar fi `greseala' ?
template1=# select to_char(date('14-Feb-1993'), 'IW');
to_char ^^
---------
06
--
Radu Greab
---
Send e-mail to '[EMAIL PROTECTED]' with 'unsubscribe rlug' to
unsubscribe from this list.
