how to subtract time in my sql

Jul 2 2013 6:55 AM
dear friends,

i  have a varchar column named "NowTime" which stores a date time value.

eg: 0/3/2013 4:25:00 AM

i want to reduce  two "NowTime" values in a query and get the difference.
Is it possible??
How can i do it??

thanks a lot.

Answers (3)