Which version of Oracle are you using, 8 or 9, cos they handle dates in quite slightly different manners. Give me a holla off list with exactly what it is you are trying to do and i'll see what i can come up with for you.
Gord. -----Original Message----- From: Osullivan Karl (RKB) Senior Analyst/Programmer [mailto:[EMAIL PROTECTED] Sent: 27 March 2003 09:18 To: CF - Development Group Subject: [ cf-dev ] OT: Minutes between two Oracle dates 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 Any views or opinions are solely those of the author and do not necessarily represent those of Channel Four Television Corporation unless specifically stated. This email and any files transmitted are confidential and intended solely for the use of the individual or entity to which they are addressed. If you have received this email in error, please notify [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
