var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Change Date Format in Mysql Table
currently my MysQL table store a feild called
and the date has to be entered as
i would like it to be
how do i do this please
sorry for asking such a silly question
Mysql uses the yyyy-mm-dd DATE/DATETIME format as it makes sorting and comparisons work correctly.
If you want mysql to covert the format on input and output, you need to use the - DATE_FORMAT(date,format) - function.
This function is of some use as well -
Returns a format string. This function is useful in combination with the DATE_FORMAT() and the STR_TO_DATE() functions.