Calculating time

[Fiona]

I have a table as below:

JOB_NAME START_DATE_TIM END_DATE_TIME
------------------------------ -------------- --------------
Polled File Update 31/10/02 00:49 31/10/02 01:22
Post Polling 31/10/02 01:22 31/10/02 02:43
Post Picking 31/10/02 02:43 31/10/02 03:55

I want to add a column called "duration" where the value is worked out by END_DATE_TIME - START_DATE_TIME.

Problem I have is then to convert this value into minutes: i.e. at the moment, the value for col Duration for the first row comes back as .02267361 and I need to find a syntax that will convert this value to 33 minutes (the actual duration)

Does any one know any syntax to do this?

Cheers
Fiona

[pando]

http://forums.dbasupport.com/forums/...threadid=30774