has anyone had any expierence with the datetime field coming back from
MSSQL as someting along the lines of February 3, 2036 6:36AM. This happens
to me no matter the time in the database. PHP inserts it correctly, but
the select has a problem. I am using php4.1.2 and SqlServer 7.0.
Or is
Could you give an example of what you are sending in as the date value
in an Insert/Update?
Adam Voigt
[EMAIL PROTECTED]
On Thu, 2002-07-25 at 08:45, [EMAIL PROTECTED] wrote:
has anyone had any expierence with the datetime field coming back from
MSSQL as someting along the lines of February
Hi,
there exists a workaround in php for this problem. Just put in your php.ini:
mssql.datetimeconvert = 0
or in your script:
ini_set('mssql.datetimeconvert' , 0);
this causes date values in this format: -MM-DD HH24:MI:SS
if it doesen't work correctly, the upgrade to php4.2.1
bye,
[EMAIL
I can't seem to find a way to format the field that comes back from my
DateTime fields in MSSQL Server. For example, '2002-05-13' shows in Query
Analyzer as 2002-05-13 00:00:00.000. If I echo it from PHP, I get May 13
2002 12:00AM. date() won't take it. strftime() won't take it. What do I
]
Subject: [PHP-DB] MSSQL DateTime field formatting?
I can't seem to find a way to format the field that comes back from my
DateTime fields in MSSQL Server. For example, '2002-05-13' shows in Query
Analyzer as 2002-05-13 00:00:00.000. If I echo it from PHP, I get May 13
2002 12:00AM. date() won't
Hi,
get the latest PHP4 and set set php.ini-param mssql.datetimeconvert to Off
the the MSSQL-Module then returns datetime-values in this format:
-MM-DD HH24:MI:SS
bye,
Benjamin Walling wrote:
I can't seem to find a way to format the field that comes back from my
DateTime fields in