Date format in MySQL table

[Inandjo]

hi,
i'm using MySQL 3.23.24 release in conjonction with BDE 1.0 and MyODBC 3.50.36, and the problem i have is that i want to be sure that under any OS, any machine, MySQL WILL store dates as yyyy-mm-dd.
I'm trying to port an application from Dbase to mysql and the date field are really problematic.

 

[petersJazz]

Try using date_format function. Example:

select date_format(wLastLogin,'%Y + %m + %d')
from Users

will return string like "2002 + 03 + 12"