changing the sql date??

[jnash]

mysql server takes a date like 1984-12-12 ? how can i change that or is it et in stone thanks!

 

[TechGnome]

IT should be able to accept *ANY* date format as long as it can figure out what you intended.... yyyy-mm-dd; dd/mm/yyyy; mm/dd/yyyy; dddd mmm dd yyyy; and so on.

-tg

 

[cjard]

Huh? A date is based on a numerical type.. It has no innate format!

If youre writing SQLS like:

SELECT * FROM table WHERE dateCol > '1984-12-20'



Then dont; learn how to write a parameterized sql and supply the date as a parameter, of type "date", not of type "string"..