Mipos xerei kaneis?

[Jimmy Angelakos]

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