Does anyone know of a quick way to convert data type of interval days to seconds (e.g. +534 11:45:36.000000) to display as just days (e.g. 534.5). Ideally, I would like to throw out weekends. I’m using crystal reports XI and oracle 10 DB. I don’t care if it’s a crystal or oracle function. I think I can do it using extract, but I was hoping there was maybe a function to do it. Is extracting the day, then extracting the hour the only way?