Thanks for the reply, jm. It worked.
Regards
r segador
--- Jean-Michel OLTRA <[EMAIL PROTECTED]> wrote:
>
> Bonjour,
>
>
> Le jeudi 26 octobre 2006, serafin segador a écrit...
>
>
> > SELECT DATE(2006-01-01) DAT1 ,
> YEAR(DATE(2006-01-01))
> > YR1 , DAYOFMONTH(DATE(2006-01-01)) VAL1 ,
> > DAYOFYEAR(DATE(2006-01-01)) VAL2 FROM DUAL
>
> SELECT DATE('20060101') DAT1, YEAR('20060101') YR1
> ....
>
> --
> jm
>
> A.E.L. Sarl (R.C.S CASTRES 490843240)
> http://www.affaires-en-ligne.com
>
>
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
