Page 1 of 1

datetime storage

Posted: Tue Mar 01, 2005 8:24 am
by dannymc1983
anyone know a way of storing date in the format dd/mm/yy in mysql? i know the datetime and date formats store dates with the year first but id like to know is there any way of manipulating this so that they store dates in the format i have outlined above?? or would i just be better off storing it as a char in mysql?

Posted: Tue Mar 01, 2005 8:37 am
by feyd
you'd best to store it in their format or as a unix timestamp.. storing in the format you wish will make it difficult to sort the information by date.

I've gone over this many many times recently and don't wish to be repeating myself all over again.. mohson's posts I think it was..