Mark
|
| Posted: 10/01/2002, 9:45 AM |
|
Hi folks
I need help displaying an Oracle date in a grid
Currently the column shows nothing when the field is set to date
When set to Text It shows e.g. 1-OCT-02
I need yyyy-dd-mm H24:MI:SS or something similar
Thanks
Mark
|
|
|
 |
Mark
|
| Posted: 10/03/2002, 4:34 AM |
|
PLease does anyone have an example of how this is done with Oracle, CCS and PHP
|
|
|
|
Mark
|
| Posted: 10/03/2002, 9:50 AM |
|
Solved with help from Alex at code Charge
|
|
|
|
tom
|
| Posted: 10/03/2002, 9:55 AM |
|
please post the solution
|
|
|
|
Mark
|
| Posted: 10/03/2002, 10:40 AM |
|
After code the line that creates connection , e.g. in CCS BugTrack example it's after
//Initialize Objects
$DBintranet = new clsDBintranet();
try to put this code
$DBintranet->query("alter session set nls_date_format='dd/mm/yyyy hh24:mi:ss' ");
|
|
|
|
Mark
|
| Posted: 10/03/2002, 10:48 AM |
|
Sorry there was a typo
I had to remove the backslash after = and the last ' to get this to work
You also need to set the grid label to text type
$DBintranet->query("alter session set nls_date_format='dd/mm/yyyy hh24:mi:ss' ");
|
|
|
|
