|
|
Posted by Serious_Practitioner on 01/01/08 19:20
Thank you, Rik and Jerry. I'll follow the lkinks and suggestions that you
made.
Steve E.
"Jerry Stuckle" <jstucklex@attglobal.net> wrote in message
news:BvudnYhhb9bOzefanZ2dnUVZ_qjinZ2d@comcast.com...
> 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
> ==================
>
Navigation:
[Reply to this message]
|