time difference

[hridya]

can any one help me

i want to ge the time difference betwwen two times

eg: time1=12:10:10
time 2:=12:20:10

i want time2-time1

[mwasif]

Hi hridya,

Welcome to TSDN!!!

Try this code
[CODE=mysql]SELECT TIMEDIFF(time2, time1) FROM table_name[/CODE]

[hridya]

thanks for helping


hridya