Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

How to find out difference between two time of the same day

User_8CW5LMay 29 2021

Hello Guys,
I came across one scenario of train station data; travelers tap in and tap out data in a day. I have two columns along with the date column one is TAP_IN (can say entering hour at the train station) and TAP_OUT (can say exit time from train station). Both columns are mentioning the only day/night time in 24HH: MM AM/PMformate. So how can I find out the difference in minutes between these two columns (difference between TAP_IN and TAP_OUT results into total minutes)?

This post has been answered by Hub Tijhuis on May 29 2021
Jump to Answer

Comments

Mike Kutz

The upgrade to a 2007+ file format?

XLS is a different format than XLSX.

They are both different than CSV.

Many times I have seen CSV files with the XLS/XLSX file extension.  This is wrong.  This is Sooo wrong.  Please ensure this is not the case.

I don't use the Data Load Wizard.  But I heard that it now supports the XLSX format.

XLS format should no longer be in use.  As such, I doubt the Data Load Wizard will ever support XLS format.

Workaround

Save the file as an XLSX file and try again.

MK

Tomek

File is XLSX.

Mike Kutz

Is it really an XLSX file? can you change the extension to ZIP and open it? (this question is a habit of mine.  I've seen too many people claim their CSV file is an XLSX file)

Does the XLSX file actually contain the correct worksheet name that the Data Load Service is looking for?

Is it spelled correctly?  (don't laugh - I once had someone misspell RAT)

Case matches? (I'm not sure if this is the case.  As I've said, I don't use Data Load Service)

Without trailing spaces?

What does the debug log say?

Sanjay Sikder

@Tomek,

File is XLSX sure? You can try again by changing the file extension. or Please re-edit the file and save it in the same format and try to upload and then upload the file.  I also had a similar problem once.

Tomek
Answer

Found the solution...

By opening it in a special repair mode and saving it, I can then open it with Apex.

pastedImage_1.png

This is the link that talks about it

Marked as Answer by Tomek · Sep 27 2020

On Data Load Definition > Data Profile > Advanced found Default Sheet Name as sheet2.xml, changed to sheet1.xml and error disappear. I did never change that property to sheet2.xml.

1 - 6

Post Details

Added on May 29 2021
6 comments
1,063 views