error getting while finding the time difference

[bindiya]

i have a mysql query nto find the time difference between current time and the time in the databse table filed.

but i get error.the datatype used in table is time.the time difference should be displayed in hours

 

my query is

SELECT TIMEDIFF(curtime, date_posted) FROM page_view

 

here date_posted is my field in the table.

[joel24]

what type of field is date_posted... datetime, unix timestamp, etc?

In TIMEDIFF() you need both the times/dates to be of the same type...

 

And do you just want the time difference, or the date difference, or both?

date & time functions

[bindiya]

the datatype for the field is datetime.

i need the time difference

[Pikachu2000]

When you get errors, it's usually helpful to post them with the code, but try this.

SELECT TIMEDIFF( NOW( ) , `date_posted` ) FROM `page_view`

[joel24]

The two times/dates need to be of the same type.

TIMEDIFF(curtime, date_posted) ... you have a time field and a datetime field.

You need to do TIMEDIFF(curtime(), TIME(date_posted))