Hi,
Sorry for the off-topic posting I want to find out the number of hours and minutes between two dates in Oracle (don't want to use CF as I'm sure DB was be more efficient). Can't quite work out the syntax. Both dates have hours and minutes in them. Eg SELECT (departure_date - arrival_date) FROM DATES_TABLE WHERE PERSON = 3 This gives me a number llke 0.043837267 but I want to get that into hours and minutes. Can I do this in Oracle? Thanks Karl O'Sullivan Senior Analyst Programmer University Hospitals Coventry and Warwickshire NHS Trust Tel: 28952 / 024 7696 8952
