April 24th, 2000, 03:52 AM
I have to calculate time difference using sql statements in MySQL. Can somebody please tell me the syntax for it.
April 24th, 2000, 11:08 PM
There are many different time manipulation functions for valid datetime columns - just check on MySQL's online manual.
A personal favorite is the to_days() function....
> select * from table_name
> where to_days(now())-to_days(activity_date)
> <= 7;
// show me all the activities that occurred within the last week.
April 28th, 2000, 09:21 AM
wht exaclty is ur requirement ?
wht time diff u wanna measure?
to_days() is always a good option ..
give some more details like wht do u want