[Amit]

I have to calculate time difference using sql statements in MySQL. Can somebody please tell me the syntax for it.

[Kyuzo]

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.

[ranjeet]

yaar amit

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

ranjeet walunj