Posted by baka on 11/19/03 11:27

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(Timestamp) and put the "." it
will work
i.e
NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS'; // NG

$db->NLS_DATE_FORMAT = '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("adodb/adodb.inc.php");
require_once("adodb/adodb-pager.inc.php");
session_start();
$db=NewADOConnection("oci8");
// If i comment the below line works fine with default oracle date
$db->NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS';
$db->Connect("slogdb","logdb","logdb");
//tried this also but bo
//$db->Execute("ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD
HH24:MI:SS'");
$sql="select ACCODE,DATEANDTIME,PATHANDFILE from logdatatbl ";
$pager=new ADODB_Pager($db,$sql);
$pager->Render($rows_per_page=6);


?>

• Next in forum: Re: Escaping Data and Replacing HTML for PHP/MySQL
• Prev in forum: Re: howto: please wait, this may take a few seconds...
• Thread view: PHP ADODB and NLS_DATE unexpected result

[Reply to this message]