Informatica PowerCenter and BI Tools Fundamentals

Time: 00:00:00

Attempted

Not Attempted

Marked For Review

Attempted & Reviewed

Question 1 of 18

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?

Select Your Answer:

GET_DATE_PART (DATE_SHIPPED,'HH')

GET_DATE_PART (DATE_SHIPPED,'HH12')

GET_DATE_PART (DATE_SHIPPED,'HH24')

All

Mark for Review

All Questions

Attempted

Not Attempted

Marked for Review

Attempted & Reviewed

Current