Wrox Home  
Search P2P Archive for: Go

  Return to Index  

pro_php thread: PHP/SQL Server datetime data type


Message #1 by "Michael Blake" <mblake@r...> on Fri, 27 Jul 2001 14:39:22
Hmm.  Pre-epoch date. I wonder....  :(

B.Page

> Hi all,
> 
> I am using $row_array = mssql_fetch_row($rsQuery); 
> echo($row_array [$iCtr]); to iterate through values in a 
> recordset. The values are coming 
> from a SQL Server 7.0 database.
> 
> My Problem: When I come across a value that is of type 
> datetime in the 
> database, I only receive 8 characters of the value to display.
> 
> Data Breakdown: SQL Server has the data as "1969-05-20 
> 00:00:00.000". The 
> value displayed in the browser is "May 20 1"
> 
> Thanks,
> Michael


  Return to Index