Test 3
Verify that data required to convert from local times for Europe/Paris into Universal Time is loaded into the database.
| Timezone | Start date | End date | UTC offset | ||||
|---|---|---|---|---|---|---|---|
| @tz_results.timezone@ | @tz_results.local_start@ | @tz_results.local_end@ | @tz_results.utc_offset@ |
Test 4
Verify that the conversions between UTC and local time work correctly.
| Locale | Time | Test Passed? |
|---|---|---|
| Oracle sysdate (should be UTC) | @system_time@ | |
| Local time in America/New_York | @NYC_time@ | |
| UTC time (converted from New York time) | @NYC_utc_time@ | @NYC_p@ |
| Local time in America/Los_Angeles | @LA_time@ | |
| UTC time (converted from Los Angeles time) | @LA_utc_time@ | @LA_p@ |
| Local time in Europe/Paris | @paris_time@ | |
| UTC time (converted from Paris time) | @paris_utc_time@ | @paris_p@ |
| Local time in Asia/Tokyo | @tokyo_time@ | |
| UTC time (converted from Tokyo time) | @tokyo_utc_time@ | @tokyo_p@ |
@footer@