fran13
Posts: 9
|
| Posted: 11/26/2007, 10:35 PM |
|
Hi there
I'm having problems with my date formatting.
I'm using MS SQL Server 2000 (with the default date settings- Oct 4 2006 12:00AM)
I used several date format settings (in the connection) and set my fields' datatype to date (with a format of dd/mm/yyyy)
The date gets stored in the db, but doesn't show in the textbox. (wich is bound to the field)
In the database my dates show in this format : yyyy/mm/dd
I tried to change the date format under Connection->Server to "Mon DD YYYY HH:MIAM" ,
but in the common.php it doesn't look right:
"DateFormat" => array("Mo", "n", " DD YYYY ", "HH", ":MIAM").
Please help!
Thanks
|
 |
 |
fran13
Posts: 9
|
| Posted: 11/27/2007, 12:31 AM |
|
YEAH!YEAH!YEAH!
I found the problem after 7 hours of struggling!!!
The problem was in the php.ini.
mssql.datetimeconvert = Off had to be uncommented (remove the ; )
|
|
|
|
|
