Kbase P4290: SQL-92: How to Demonstrate the Use Of TO_CHAR function ?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/15/2008 |
|
Status: Verified
GOAL:
How to Demonstrate the Use Of TO_CHAR function ?
GOAL:
How to use the TO_CHAR function in SQL-92 from JDBC or ODBC application
FACT(s) (Environment):
Progress 9.x
FIX:
- Run the following statements from ODBC or JDBC application :
drop table T2;
create table T2 (theDate timestamp);
insert into T2 (theDate) values ({ ts '1965-02-03 12:30:45'});
commit;
- Running the following should return : "Wednesday February 3rd 1965 - 12:02:45"
select to_char(thedate,'Day Month ddth yyyy - HH:MM:SS') from T2;