Hello,
OK - WEEK(date,1) is what I was looking for, thank you.
Now I only need the possibility of choosing if week #1 of the year is the
week where 1st. Jan is (standard) or it is the first January week with four
or more days (ISO week).
(as an example, Jan 1 1999 is week 53 1998; week ISO #1 on 1999 is the week
starting on Monday 4)
I apologize if it is too obvious, I am really new to SQL and mySQL.
Regards,
Juan
-----Mensaje original-----
De: Johan Engström <johan.engstrom@stripped>
Para: Juan Riera <jriera@stripped>; mysql@stripped
<mysql@stripped>
Fecha: miércoles 17 de marzo de 1999 9:36
Asunto: Re: Formatting date as week # - is it possible on mySQL?
>JR>- Is there any SQL function that formats date as week ?
>JR>- Is there any way of defining a function on SQL to do that?
>
>Check out the documentation:
>
>http://www.tcx.se/Manual_chapter/manual_Reference.html#Date_and_time_functi
o
>ns
>
>Best regards,
>
>Johan
>
>
>---------------------------------------------------------------------
>To request this thread, e-mail mysql-thread388@stripped
>To unsubscribe, e-mail the address shown in the
>List-Unsubscribe header of this message.
>For additional commands, e-mail: mysql-help@stripped
>
>
