Hello,
Here i am having sample program to display selected data on the browser
with Pager functionality of ADODB_Pager.
If i include the NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS';
then the Date column field itself disappear from the display.
if I comment it default date will be displayed.
If i remove the ":" from the Seperator(Times tamp) and put the "." it
will work
i.e
NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS'; // NG
$db->NLS_DATE_FORMA T = 'YYYY-MM-DD HH24.MI.SS'; //OK
My environment
Oracle 10.1.x
PHP 5.0X
Apache 2.x
OCi8
ADODB Latest
Browser IE 6.0
can any one have the clue,
Thanks in Advance
--Here is the working code
<?php
require_once("a dodb/adodb.inc.php") ;
require_once("a dodb/adodb-pager.inc.php") ;
session_start() ;
$db=NewADOConne ction("oci8");
// If i comment the below line works fine with default oracle date
$db->NLS_DATE_FORMA T = 'YYYY-MM-DD HH24:MI:SS';
$db->Connect("slogd b","logdb","log db");
//tried this also but bo
//$db->Execute("ALT ER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD
HH24:MI:SS'");
$sql="select ACCODE,DATEANDT IME,PATHANDFILE from logdatatbl ";
$pager=new ADODB_Pager($db ,$sql);
$pager->Render($rows_p er_page=6);
?>