Multiple choice technology platforms and products

A database field requires the hour that an order is shipped. The date is stored in 24 Hr format. Which of the following examples will return the value 22 for an order shipped on Aug 15 2009, at 10.15 PM?

  1. GET_DATE_PART (DATE_SHIPPED,'HH')

  2. GET_DATE_PART (DATE_SHIPPED,'HH12')

  3. GET_DATE_PART (DATE_SHIPPED,'HH24')

  4. All

Reveal answer Fill a bubble to check yourself
D Correct answer