List:General Discussion« Previous MessageNext Message »
From:Fabrizio Tivano Date:July 2 2003 6:07pm
Subject:possible query #2
View as plain text  
Hello dear all,

on MySQL 3.23.54
i have a table that list the number of  user-time days like:  35 

whell....based 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 possible? 
...if yes how?

...or there is only a madness? :)

thanks in advance, 
fabrizio
Thread
possible query #2Fabrizio Tivano2 Jul
  • Re: possible query #2Victoria Reznichenko3 Jul