Use this function to convert a time from one format to another.
Time2Time (OldTime, OldFormat, NewFormat)
Parameter |
Description |
OldTime |
Enter a valid time string. The system assumes your entry is in the time format specified in the OldFormat parameter. The default is the current time. |
OldFormat |
Enter a valid time format that describes the OldTime parameter. The default is time format 1 (HH:MM:SS). |
NewFormat |
Enter a valid time format that describes the format you want the OldTime converted to. The default is time format 1 (HH:MM:SS). |
Here is an example:
(Assume T1 is 01:30:05 pm.)
Function |
Result |
Explanation |
Time2Time("T1", "2", "1") |
13:30:05 |
Takes the time in T1 (which is in format 2) and converts it to format 1. |
© Copyright 2014, Oracle and/or its affiliates. All rights reserved. Legal notices.