FreeTDS Development Group

["Sam Sam" <s4m AT lycos.com>]

hello,
I've some problem on accessing ms sql 7.0 date type variables. Since php 4.0 
fetch array into string variables.. I always get string variables with 12:00 
AM inside. e.g if the value in ms sql 7.0 '11/11/2000' then i got '11/11/2000 
12:00 AM' in my php's variables.. 

I've no idea how to fetch date types variables from ms sql 7.0. Anyone know 
how to solve my problem ?

thx,
Sam


Get your FREE Email and Voicemail at Lycos Communications at
http://comm.lycos.com

From bkline AT rksystems.com Tue Oct 03 09:30:29 2000
Return-Path: <bkline AT rksystems.com>
Received: from rksystems.com ([209.50.228.97]) by franklin.oit.unc.edu with 
SMTP (Lyris List Manager SOLARIS/SPARC version 4.0); Tue, 03 Oct 2000 
09:30:23 -0400
Received: from localhost (bkline@localhost)
        by rksystems.com (8.9.3/8.9.3) with ESMTP id JAA26891
        for <freetds AT franklin.oit.unc.edu>; Tue, 3 Oct 2000 09:42:02 -0400
Date: Tue, 3 Oct 2000 09:42:02 -0400 (EDT)
From: Bob Kline <bkline AT rksystems.com>
To: TDS Development Group <freetds AT franklin.oit.unc.edu>
Subject: Re: date type in ms sql 7.0
In-Reply-To: 
<LYRIS-94270-82962-2000.10.03-09.20.20--bkline#rksystems.com AT franklin.oit.unc.edu>
Message-ID: <Pine.LNX.4.10.10010030938560.26841-100000 AT rksystems.com>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII


On Tue, 3 Oct 2000, Sam Sam wrote:

> hello, I've some problem on accessing ms sql 7.0 date type
> variables. Since php 4.0 fetch array into string variables.. I
> always get string variables with 12:00 AM inside. e.g if the value
> in ms sql 7.0 '11/11/2000' then i got '11/11/2000 12:00 AM' in my
> php's variables..
> 
> I've no idea how to fetch date types variables from ms sql 7.0.
> Anyone know how to solve my problem ?
 
1. Chop off the part you don't want; or
2. Use the CONVERT function with the style you want.

-- 
Bob Kline
mailto:bkline AT rksystems.com
http://www.rksystems.com