datetime storage

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
dannymc1983
Forum Commoner
Posts: 80
Joined: Wed Feb 16, 2005 7:24 am

datetime storage

Post 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?
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post 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..
Post Reply