Mipos xerei kaneis?

[m65 at vivodinet.gr]

Jimmy Angelakos wrote:
> m65 at vivodinet.gr wrote:
> 
>>Ma resi, pos tha valo ta stoixeia, kai poia stoixeia tha valo sto 
>>temporary ( hic!) otan (HIC! ) ta dedomena einai null! dioti den 
>>katalaveni ta dedomean ( jjhic!__)
>>
>>loipon ta xo poiei
>>kalinihta!
> 
> 
> 
> Ta stoixeia 8a ta baleis ston temporary pinaka ws strings.
> 
> Meta 8a kaneis:
> 
> CAST(CONCAT(SUBSTRING_INDEX(string, '-', -1), '-',
> SUBSTRING_INDEX(SUBSTRING_INDEX(string, '-', 2), '-', -1), '-',
> SUBSTRING_INDEX(string, '-', 1)) AS DATE))
> 
> An den katalabaineis ti grafw anoi3e to mysql manual otan sunel8eis ;)
> 
> 
> Mhtsos
> 
> 
Ok sinerhomai kai tha to do kai afto :-p :-)
Thanks!