Kbase P48948: How can I change default date format in SQL-92?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/16/2008 |
|
Status: Unverified
GOAL:
Can I set default date format for SQL-92 ODBC Driver?
GOAL:
How to change date format in SQL-92?
FACT(s) (Environment):
Progress 9.x
OpenEdge 10.x
FIX:
Use "to_char()" scalar function to change the display format of the date, e.g. "select(mydate,'dd.mm.yyyy') from mytable". There is no other optional way to change date format in SQL-92.