Easily find issues by searching: #<Issue ID>
Example: #1832
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
Hello,
If I run a sql statement which returns a date (the column in the table is a real date in *iso format) the date is returned as 27/12/2012.
Is there a way to chasnge the format?
Thanks, Rob
|
|
140 KB
Can you try the following:
1) Go to File -> Options -> Results Format -> DB2 iSeries
2) In the datatype dropdown, choose the appropriate column datatype: date or time or timestamp
3) In the "For" column, change the value from "[Default]" to a custom format.
4) Click "OK" and then re-execute your query.
Or, maybe you are looking to do the following:
Or, maybe you are looking to do the following:
Yes I did change them on the driver prior to posting the question (date format=iso). It had no effect.
But I then followed your instruction in File -> Options -> Results Format -> DB2 iSeries and changed it to none.
When I reran the query the date was in *ISO format. So it must now be using the driver's date format.
Thanks, Rob
Yes I did change them on the driver prior to posting the question (date format=iso). It had no effect.
But I then followed your instruction in File -> Options -> Results Format -> DB2 iSeries and changed it to none.
When I reran the query the date was in *ISO format. So it must now be using the driver's date format.
Thanks, Rob
Issue #8493 |
| Closed |
| Fixed |
| Resolved |
Completion |
| No due date |
| No fixed build |
| No time estimate |
Can you try the following:
1) Go to File -> Options -> Results Format -> DB2 iSeries
2) In the datatype dropdown, choose the appropriate column datatype: date or time or timestamp
3) In the "For" column, change the value from "[Default]" to a custom format.
4) Click "OK" and then re-execute your query.