I have an Oracle database and two columns (start_date_time and end_date_time)where I store the date and time in these columns. Using TOAD for Oracle when I query these columns I recieve the data and time. Using TDA Query Builder I only get the date. Can I get the date and time in the query builder or do I need to create a report.
A second question: I want to subtract the end date/time from the start date/time to tell how long the process is taking. Currently I have an excel spreadsheet that does all this processing and I am trying to mirror in TDA. Would the best way be to do the subtraction after sending the data to the excel spreadsheet? Thank you for the assistance.