Posted by Jerry Stuckle on 01/01/08 14:37

Serious_Practitioner wrote:
> Good day, and Happy New Year!
>
> I'm trying to teach myself some PHP and MySQL and the project that I've
> decided to build will be dependent on queries involving comparisons of
> dates. I'd like some advice, please, on whether I should -
>
> 1. Store the date (2008-01-01) in the MySQL table as a date and compare to
> that, or...
> 2. Create a/ timestamp/s for the date/s in question, store the timestamp and
> then compare to that.
>
> If the timestamp is the way to go, should that column be of type "Timestamp"
> or will that cause the string to be altered to a MySQL timestamp?
>
> Thank you in advance for any assistance.
>
>
> Steve E.
>
>
>
>
>

Try comp.databases.mysql - where the MySQL experts hang out. They can
tell you the best way to do it.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

• Next in forum: Re: text file download on .php page
• Prev in forum: M.I 5.Per secution . w hy wo n't the Brit ish poli ce do the ir jo b and put a sto p to i t?
• Thread view: Re: Date storage format

[Reply to this message]