📚 Practice Mode

Informatica PowerCenter and BI Tools Fundamentals

Learn at your own pace with hints and detailed explanations

1 / 18
Multiple Answers

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
Change Mode