Posted by Kailash Nadh on 11/26/07 03:31

Your method would be ideal. (mktime)
It is BETTER to store timestamps as INTs rather than DATETIME.
A simple, X(int) > INT AND X(int) < INT is definitely faster than a
comparison involving DATETIME fields.

Regards,
Kailash Nadh
http://kailashnadh.name

On Nov 22, 12:38 am, kanwal <way2kan...@gmail.com> wrote:
> Hi,
>
> I have millions of records in my xxxxx table in mysql. And I have a
> column of time in which I have stored the timestamp using php time()
> function.
>
> Now I wanna write an SQL query to fetch the records either for year
> (2006) or for month and year (Jan 2006)
>
> Currently I had implement this logic:
> To find records for March 2006
>
> start time = mktime( for Feb 2006 )
> end time = mktime( for April 2006 )
>
> I am searching the records greater than start time and lesser than end
> time.
>
> Is there any other simple way to do so.
>
> Thanks.

• Next in forum: Re: Executing Multiple Queries using MDB2
• Prev in forum: Re: browser waits forever on my script
• Thread view: Re: Want search on timestamp ! Any other alternative ??

[Reply to this message]