How to save date in oracle database

[andy136 (359977082)]

Hi, guys

I want to save a date value in oracle db.

And the code is as follow:

DB:

LAST_VISIT_DATE  DATE NULL

PHP CODE:

$cur_date = date('Y-m-d H:i:s');

$user->LAST_VISIT_DATE = "to_date($cur_date,'yyyy-mm-dd hh24:mi:ss')"; 

I want to use $user->update() to save the user information.

Though, somebody give a method of using the sql statement as follow:

UPDATE CS_WAITER SET LAST_VISIT_DATE = "TO_DATE"('2011-11-01 11:30:00', 'yyyy-mm-dd 


hh24:mi:ss');

I just want use $mode->update method. Can you give me some suggestion? Thanks a lot.

[andy136 (359977082)]

1. Every time you are working with blobs and queries you have to check some BDE parameters.

the entry BLOB SIZE defines the amount in KB you can fetch from a blob field. The default value is set to 32KB !!! But remeber this value does only affect TQuery not TTable.

2. Oracle knows different types of LONG fields

When creating a Oracle table using LONG fields you have the following two posibilities :

2.1 Creating a long text field

CREATE TABLE TEST

( KEY NUMBER(*),

DATA LONG );

This statement creates a table with a numeric id an a textfield of "unlimited" size. Note here that the BDE restricts a BLOB field to a max of 1000KB.

The content of this field wil be translated according to the national settings of the client and the server. Due to that behavior you will never be able to store a binary datablock unchanged into a Oracle LONG field.

2.2 Creating a long binary field

CREATE TABLE TEST

( KEY NUMBER(*),

DATA LONG RAW);

This statement creates the same table as above, but with a raw datafield. RAW mean Oracle doesn’t matter about the content of the field. So whatever you put into tis kind of field, it wil be stored as is.

3. Unicode data

I think there wil be a way to set up a Oracle database with an unicode charset, but I’ve never seen it yet.

4. How to avoid runtime problems.

4.1 Setting the correct BDE Parameters

The TDataBase component has a params property. Through this Stringlist you can feed the database with BDE parameters.

Thanks lucychen!