Afficher un message
Vieux 18/02/2008, 17h36   #1
Alessandro
Aucun Avatar
 
Messages: n/a
Hébergeur:
Par défaut Different MSSQL output date format from the same PHP script

Hi list!

A quick question (and I hope a quick answer!).

I have a Windows Server 2003 R2 SP2 box where MS SQL 2000 SP4 is
running.
I have a debian "sarge" box running apache 2.0.54-5sarge2 and
libapache2-mod-php4 4.3.10-22.
I have another debian "lenny" box running apache 2.2.8-1 and
libapache2-mod-php 5 5.2.5-2.

On the two servers I have the same php script that queries a database
on the SQL server. One of the queried colums holds a datetime, and I
have that the output format is different between the two servers:
lenny server: Jun 7 2007 12:00:00:000AM
sarge server: Thu Jun 7 00:00:00 2007 <- this is what I want

I did not use any interpolation function (like strtotime()) but the
outcome is different.
How can I have the same output on the lenny server? Is this a server
configuration issue or what else? I would like not to use any php
function because I want to migrate my scripts from the old server to
the new one with the minimum effort.

TIA
--Alessandro
  Réponse avec citation
 
Page generated in 0,04530 seconds with 9 queries