Re: possible query #2

2003-07-03 Thread Victoria Reznichenko
Fabrizio Tivano <[EMAIL PROTECTED]> wrote: > > on MySQL 3.23.54 > i have a table that list the number of user-time days like: 35 > > whellbased on curdate() function > > can i able to make a select wich display the sum (150-35) > where 150 is date_format(curdate(), '%j') > in a format l

possible query #2

2003-07-02 Thread Fabrizio Tivano
Hello dear all, on MySQL 3.23.54 i have a table that list the number of user-time days like: 35 whellbased on curdate() function can i able to make a select wich display the sum (150-35) where 150 is date_format(curdate(), '%j') in a format like (%d/%m/%y) ? this kind of query is poss