Skip to Content.
Sympa Menu

freetds - date type in ms sql 7.0

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Sam Sam" <s4m AT lycos.com>
  • To: freetds AT franklin.oit.unc.edu
  • Subject: date type in ms sql 7.0
  • Date: Tue, 03 Oct 2000 06:20:24 -0700


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





Archive powered by MHonArc 2.6.24.

Top of Page