Subtracting Dates in MySQL

Can you subtract one datetime rows from another datetime place?

[sawatkins]

The title pretty much says it all. I have two rows formatted in datetime. Can I subtract one from the other, like

SELECT DATE_SUB(`endtime`, `starttime`)

Thanks in advance for the help!

</g>

[ashish21cool]

try to subtract using "-"
Datetime1 - Datetime2
Let me know if this solves you problem.

[rocknbil]

Sure you can, but I think you are looking for datediff() [dev.mysql.com] or timediff() [dev.mysql.com].