new_time returns the date and time in time zone zone2 when date and time in time zone zone1 are date. Before using this function, you must set the NLS_DATE_FORMAT parameter to display 24-hour time.