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)

SQL