Code Forums - View Single Post - Problems in date DESC after changing format

sde · 04-02-2006, 08:57 AM

i'm lost on what exactly your problem is. if there is still a problem, demonstrate a query you use to insert the datetime field.

you've already demonstrated how you get it out. for getting it out, i prefer the unix_timestamp method because PHP has more date formatting options than MySQL.

some go as far as to just store the unix time stamp in an int(14) field. i prefer to keep it in a datetime format in the database so i can utilize the MySQL date functions in my queries.

04-02-2006, 08:57 AM	#6 (permalink)
sde Moderator Join Date: May 2002 Location: us.ca Posts: 4,529	i'm lost on what exactly your problem is. if there is still a problem, demonstrate a query you use to insert the datetime field. you've already demonstrated how you get it out. for getting it out, i prefer the unix_timestamp method because PHP has more date formatting options than MySQL. some go as far as to just store the unix time stamp in an int(14) field. i prefer to keep it in a datetime format in the database so i can utilize the MySQL date functions in my queries.