Date format for now() and WorkOrder.CreatedTime

Hi!

I want to see difference beetween createdtime and now.

In query report wrote something like this:

SELECT wo.WorkOrderId, au.First_name, dd.deptName 'Отдел', LONGTODATE(wo.CreatedTime), wo.Title, LONGTODATE(wo.closeauthkey), sd.statusName, (DATE_FORMAT(now(), '%b %e, %Y %h:%i %p')) 'Time now', FROM WorkOrder wo LEFT JOIN WorkOrderStates wos ON wo.WorkOrderId = wos.WorkOrderId LEFT JOIN StatusDefinition sd ON sd.statusId = wos.statusId LEFT JOIN SDUser ON SDUser.userId = wos.ownerId LEFT JOIN Aaauser au ON au.user_id = SDUser.UserId LEFT JOIN DepartmentDefinition dd ON dd.deptId = wo.deptid

WHERE wos.StatusId = 1 AND wo.createdtime >= <from_today>

But time from function "now()" has format in number like 20121212235959 and i can't use subtraction for this 2 dates and can't calc difference beetween them.