IBEX Posted December 9, 2008 Report Share Posted December 9, 2008 sveiki, jautajums ir sekojosh.. $sql = "INSERT kautkas SET Birthdate = cast('$Birthyear-$Birthmonth-$Birthday' )"; ievietoju shādi datubāzē un vai pēc tam ir iespēja, pa vienma arī vinjus izvilkt ārā? Birthyear radas viena rinda Birthmonth otra Birthday piemeram tresha.. Ludzu paskaidrojiet, ka pec tam man izvilkt ara? vai ari ir kads cits variants?.. Link to comment Share on other sites More sharing options...
Delfins Posted December 10, 2008 Report Share Posted December 10, 2008 kas par bāzi? MSSQL vismaz ir select year(x), month(x), day(x) from Z Link to comment Share on other sites More sharing options...
IBEX Posted December 10, 2008 Author Report Share Posted December 10, 2008 MySQL client version: 5.0.22 Link to comment Share on other sites More sharing options...
Aleksejs Posted December 10, 2008 Report Share Posted December 10, 2008 http://dev.mysql.com/doc/refman/5.0/en/dat...ml#function_day http://dev.mysql.com/doc/refman/5.0/en/dat...#function_month http://dev.mysql.com/doc/refman/5.0/en/dat...l#function_year Tu vispār pamēģināji, ko Delfins uzrakstīja? Link to comment Share on other sites More sharing options...
Recommended Posts