Differences

This shows you the differences between two versions of the page.

oracle-to-mysql:timestamp_with_time_zone [March 22, 2013 7:30 am]
sqlines
oracle-to-mysql:timestamp_with_time_zone [March 22, 2013 9:32 am] (current)
sqlines
Line 64: Line 64:
| SFO | Virgin Atlantic | VS020 | 23-MAR-13 01.25.00.000000 AM | | SFO | Virgin Atlantic | VS020 | 23-MAR-13 01.25.00.000000 AM |
| LHR | Singapore Airlines | SQ2507 | 22-MAR-13 11.25.00.000000 AM | | LHR | Singapore Airlines | SQ2507 | 22-MAR-13 11.25.00.000000 AM |
 +
 +**Note.** [[/sqldata/oracle-to-mysql|SQLines Data]] tool is capable of converting TIMESTAMP WITH TIME ZONE data to the UTC time zone in MySQL using SYS_EXTRACT_UTC function automatically.
Then depending on the application you can store time zone information in a separate column of the same table, or in a separate table. Then depending on the application you can store time zone information in a separate column of the same table, or in a separate table.