You use the right tool for the job. MySQL is going to have to format the
date field for the return anyway. It makes sense to simply tell MySQL
your preferred format instead of having it returned to you in the wrong
format and then you having to apply more gear to get it into the right
one.
-Rasmus
On Sun, 13 Jan 2002, DL Neil wrote:
> Rasmus,
>
> I have held several datetime-related conversations with people recently, and another
>series about 'when'/whether
> to use PHP or MySQL functionality.
>
> Here you are, "the man" of PHP, advising Sander to use MySQL functionality! (and in
>marked contrast to the
> (biased) advice one might expect on PHP lists, eg JDEW's reply) I'm grinning at the
>apparent incongruity, but
> with no insult to yourself.
>
> Would you care to comment further on when one should consider using SQL commands in
>favor of implementing
> identical functionality in PHP (and possibly in some situations, vice-versa)?
>
> Regards,
> =dn
>
>
>
> - Original Message -
> From: "Rasmus Lerdorf" <[EMAIL PROTECTED]>
> To: "Sander Peters" <[EMAIL PROTECTED]>
> Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> Sent: 13 January 2002 19:52
> Subject: [PHP-DB] Re: [PHP] convert /mm/dd to mm/dd/, how?
>
>
> > MySQL has plenty of functions to return dates to you in any format you
> > specify. Please read
> >
>http://mysql.com/documentation/mysql/bychapter/manual_Reference.html#Date_and_time_functions
> > and pay special attention to the DATE_FORMAT() function.
> >
> > -Rasmus
> >
> >
> >
> > On Sun, 13 Jan 2002, Sander Peters wrote:
> >
> > > Hello everybody,
> > >
> > > convert /mm/dd to mm/dd/, how?
> > >
> > > MYSQL does everything in /mm/dd.
> > > I live in the Netherlands and we are use to the format dd/mm/.
> > >
> > > What's the best way to display it as mm/dd/ in a table on a query?
> > >
> > > My first idea whas to split the date up in vars in php and then print
> > > the vars in the way I like it
> > > Is this a bad idea? Or are there better sollutions?
> > >
> > > Thanx in advance for answering!
> > >
> > >
> > >
> > > --
> > > Met vriendelijke groet / With Greetings,
> > >
> > > Sander Peters
> > >
> > >site: http://www.visionnet.nl/
> > > email: mailto:[EMAIL PROTECTED]
> > > webmail: mailto:[EMAIL PROTECTED]
> > >
> > >
> > >
> > > --
> > > PHP General Mailing List (http://www.php.net/)
> > > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > > For additional commands, e-mail: [EMAIL PROTECTED]
> > > To contact the list administrators, e-mail: [EMAIL PROTECTED]
> > >
> >
> >
> > --
> > PHP Database Mailing List (http://www.php.net/)
> > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
> > To contact the list administrators, e-mail: [EMAIL PROTECTED]
> >
> >
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
