1. ensure that your table has the TIMESTAMP datatype in a column.
2. ensure that your table is populated with TIMESTAMP data in that column.
3. execute a query on the table to generate results, and ensure the TIMESTAMP format is the default.
3. In File > Options > Results Formta > Greenplum change the format of TIMESTAMP to yyyy.MM.dd G 'at' HH:mm:ss z
4. Right click on the table and choose "Script to New Window As ... > Select *"
5. execute the query. The results format for the TIMESTAMP datatype has not changed.
6. compare with PostgreSQL 8.2, the format changes following the change in Results Format Options.
See attached screenshots.
This problem is a little hard to track down, root cause is a couple lines of server specific code missing in the AFProperties.java.
You might want to apply the same test case to Vertica and SQLite, I did not seen corresponding code in AFProperties.getFormatDatabase().
Issue #8039 |
Closed |
Fixed |
Resolved |
Completion |
No due date |
Fixed Build trunk/30528 |
No time estimate |
This problem is a little hard to track down, root cause is a couple lines of server specific code missing in the AFProperties.java.
You might want to apply the same test case to Vertica and SQLite, I did not seen corresponding code in AFProperties.getFormatDatabase().