ive been asked to create a table that includes
Entry time (m.sshh) eg. 0.3506 (store as a number)
Final time (m.sshh) eg. 0.3506 (store as a number)
how do I format this when I create the table? I've tried
CREATE TABLE S_ENTRY
entry_time number (m.sshh),
final_time number (m.sshh)
The basic answer is: do not store them as numbers.
You are looking for Interval Literals, especially the
DAY TO SECOND type ones.
Please read the linked documentation, you should get why it fits you needs.