Hi
All
This is samiuddin. I am having table in mysql which contain two fields like pickupdate and pickuptime.

I am using the query on this table to add time

suppose the pickupdate column is having the value as 2012-08-06 and pickuptime is having the value as 23:00:00

select addtime('pickupdate pickuptime','2:00:00') from xyz ;

but it is not adding the time, it is giving the result as 2:00:00

but when I am writing the function with direct values it is working properl.
select addtime('2012-08-06 23:00:00' ,'2:00:00')
it is giving the result as 201208-07 1:00:00


please help me out to resolve the issue

thanks
MD.Samiuddin