Skip to Content.
Sympa Menu

freetds - RE: date type in ms sql 7.0

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Wasson, Tim" <WassonT AT kochind.com>
  • To: "'TDS Development Group'" <freetds AT franklin.oit.unc.edu>
  • Subject: RE: date type in ms sql 7.0
  • Date: Tue, 3 Oct 2000 08:32:11 -0500


That's exactly the behavior I get with both SQL 6.5 and 7.0. It's normal.
PHP likes to treat everything as strings, I end up just trimming off what I
don't need. You could use the mktime function in php to convert a
string-like date into a timestamp value.



> -----Original Message-----
> From: Sam Sam [SMTP:s4m AT lycos.com]
> Sent: Tuesday,October 03,2000 8:20 AM
> To: TDS Development Group
> Subject: [freetds] date type in ms sql 7.0
>
> 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
>
> ---
> You are currently subscribed to freetds as: [WassonT AT kochind.com]
> To unsubscribe, forward this message to
> $subst('Email.Unsub')





Archive powered by MHonArc 2.6.24.

Top of Page