2. PHPRunner General questions
  3. Date formating
This topic is locked

Date formating

 		10/23/2006 8:06:11 AM
PHPRunner General questions
J
 jje author

Using phprunner v3.0, I select the date from three dropdown select listings - year, month and date

If I select the following date: 2006, May, 1 then in the Oracle database it stores this as 2006-5-1
Is dit possible that I can get this stored in the database in the format 2006-05-01 (The date field in the database is defined as varchar2)
Alexey admin 10/23/2006

Hi,
you can do this modifying generated PHP files.

Open include\commonfunctions.php file with a text editor, find this line there:

return sprintf("%d-%d-%d",$y,$m,$d);



and replace it with:

return sprintf("%04d-%02d-%02d",$y,$m,$d);
J
 		jje author 10/23/2006

Hi,

you can do this modifying generated PHP files.

Open include\commonfunctions.php file with a text editor, find this line there:
and replace it with:


Hi,
I am still using the old version 3.0 and this file include\commonfunctions.php do not exist.
Alexey admin 10/23/2006

Modify include/..._functions.php file the same way.
J
 		jje author 10/24/2006

Modify include/..._functions.php file the same way.


Thank you very much for your help