Posted by Vincent Delporte on 01/11/07 19:43

On 10 Jan 2007 20:02:21 -0800, "ZeldorBlat" <zeldorblat@gmail.com>
wrote:
>I prefer to keep datetime values as timestamps until the last possible
>moment when I format them for display.

Thanks for the idea, but I still have to display dates as dd/mm/yyyy
since this is the normal way to display dates over here.

Isn't there a way to configure MySQL to save dates this way, and avoid
massaging dates between PHP and MySQL? That would also make SELECTs
easier (SELECT * from, instead of having to name all columns just to
call some date function like UNIX_TIMESTAMP() or DATE_FORMAT() ).

Thanks.

• Next in forum: Re: [PHP4] Upload progress meter
• Prev in forum: Re: [Date] Converting dd/mm/yyyy to YYYY-MM-DD?
• Thread view: Re: Converting dd/mm/yyyy to YYYY-MM-DD?

[Reply to this message]