Ask Question
31 October, 21:21

Display flight number, origin, destination, fl_orig_time as - -"Departure Time", fl_dest_time as "Arrival Time". Format times in Miltary time (24 hour format) with minutes. Order results by flight number. Hint the format should be in 'hh24:mi'format.

+3
Answers (1)
  1. 31 October, 21:38
    0
    Select "flight number", origin, destination, format (fl_orig_time, 'HH:mm') as "Departure Time", format (fl_dest_time, 'HH:mm') as "Arrival Time" from table_name order by flight_number

    Explanation:

    The script is used to select records from the table named 'table_name' and formatted to 24hr time format with the hour in capital letters (signifying 24 hrs). Then the inverted comma used for flight number is due to the space character ebtween the two words. In a select statement, order by comes after the table name. While as is used as an alias for a column in a table.
Know the Answer?
Not Sure About the Answer?
Get an answer to your question ✅ “Display flight number, origin, destination, fl_orig_time as - -"Departure Time", fl_dest_time as "Arrival Time". Format times in Miltary ...” in 📙 Computers & Technology if there is no answer or all answers are wrong, use a search bar and try to find the answer among similar questions.
Search for Other Answers