Oracle timestamp in framework 2

For programming and general questions on Zend Framework

Oracle timestamp in framework 2

Postby wenf886 on Sat Sep 28, 2013 3:22 am

I met a problem. It took me several hours but failed.
I am using zend framework 2 and trying to insert current time stamp into oracle database table.
In my oracle database,
to_timestamp('2000-1-1 0:0:0', 'yyyy-mm-dd hh24:mi:ss') can be inserted as data in sql sentence.

I have tried several ways in zf2 controller.
like:
$data['ts_last_login'] = date('Y-m-d H:i:s');
or
$data['ts_last_login'] =Zend_Db_Expr('NOW()'); Actually, I can't find Zend_Db_Expr in framework 2.

But both fails. (invalid month) Who can help me ? THanks in advance.
wenf886
 
Posts: 1
Joined: Sat Sep 28, 2013 3:17 am

Re: Oracle timestamp in framework 2

Postby chetzel on Sat Sep 28, 2013 1:12 pm

Hi,

please check your NLS_DATE_FORMAT/NLS_TIMESTAMP_FORMAT session parameters:

Code: Select all
select   *
from   nls_session_parameters


I suppose they have the wrong format. Set these parameters appropriately. Inserting timestamps as simple strings should then be possible even without "to_timestamp()"!

Regards, Carsten
chetzel
 
Posts: 39
Joined: Mon Aug 17, 2009 4:56 pm


Return to Zend Framework

Who is online

Users browsing this forum: No registered users and 12 guests