Using PHP to save system date in Oracle table

[hueymoo]

I am attempting to write a php code to do an internal on line survey.  We want to date stamp the answers to the survey questions and store them in Oracle.

I know how to get the system date using the date function in PHP, but I"m having trouble actually storing it in a date type field in Oracle

[igor berger]

Will storing it as a Unix stamp help?

Then you can just store it as a number, later read it and convert it to date.

[hueymoo]

Sorry no, we have no unix here whatsoever and I want to use the resulting Oracle table in a report in another tool

[igor berger]

You do not need a unix server.

 

PHP will give you a date as a UNIX stamp number! You can use another PHP function to convert that number to a date format!

 

Look up the date() www.php.net it will lead you to the unix date

[Feenix566]

There are two ways to do this. If you want to store the date from the database server, you would execute a query like this:

 

insert into table(field)values(sysdate)

 

If you want to store the date from the web server, you would do this:

 

$current_time = date("d M Y H:i:s");

$insert = OCIParse($DB, "insert into table(field)values(to_date(:value, 'dd Mon yyyy hh24:mi:ss'))");

ocibindbyname($insert, ":value", $current_time);

OCIExecute($insert);

OCIFreeStatement($insert);

 

 

 

Of course, if your database and your web server reside on the same machine, it doesn't matter which one you use. It only matters if they're on two different machines and the clocks are off.