Summer Deals - hours only!Up to 80% off on all courses and bundles.-Close
Introduction
Dates
Time
12. Time with logical operators
Timestamps
Extract functions
Timezone conversion
Intervals
Current date and time
Review

Instruction

As you can see, the format for this type of data is hh:mm:ss, where hh stands for hours, mm for minutes and ss for seconds. This type of column requires apostrophes, just like dates.

SELECT code, departure
FROM route
WHERE arrival = '14:25:00';

Time requires the use of a 24-hour system (i.e., you should write 14:25 instead of 2:25 PM and 03:10 instead of 3:10 AM etc.). You can also use other comparison signs: <, <=, >, >=, !=.

Note: The Oracle database does not support the data type time, even though it is in SQL Standard.

Exercise

Show the code of the route with the scheduled arrival time of 9:30 AM.

Stuck? Here's a hint!

Remember the proper time format and use apostrophes: 'HH:MM:SS'. Don't use 'AM'.