Kbase P10574: Can the Date format be configured at the JDBC Driver Level with SQL-92?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
15/10/2008 |
|
Status: Verified
GOAL:
Can the Date format be configured at the JDBC Driver Level with SQL-92?
GOAL:
Can you change the Date format at the JDBC Driver level with SQL-92?
FACT(s) (Environment):
Progress 9.x
FIX:
No, the JDBC Driver does not allow changing the Date format. In order to change the Date format, use the SQL-92 TO_DATE function within the SQL statement. The TO_DATE function converts the given date literal to a date value.