Skip to Content.
Sympa Menu

freetds - Re: Sybase ASA Date Range ?

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Brian Bruns <camber AT ais.org>
  • To: TDS Development Group <freetds AT franklin.metalab.unc.edu>
  • Subject: Re: Sybase ASA Date Range ?
  • Date: Mon, 29 Apr 2002 08:06:47 -0400 (EDT)


I believe this is due to our use of strftime(). Somebody was cooking up a
replacement for it, but I don't know where that stands? It's a
semi-documented bug...usually pops up with dates prior to 1970 though.

Brian

On Mon, 29 Apr 2002, jekend wrote:

> I encountered a puzzling problem . as follow :
>
> create table dtest(d date);
> insert into dtest values('2099-12-31');
>
> In Interactive SQL :
> select * from dtest ;
> It displays '2099-12-31' , it is right;
>
> But In php ( via freetds )
> It displays 'Nov 24 1963 05:31PM'
>
> I found that , PHP will make a mistake when the value is larger than
> 2038-01-19 .
> I wonder if it is a bug of freetds , or is due to the difference between
> ASA and ASE .
> Anyway, Freetds is to support ASE .
> Is there any way to solve it ?
>
>
> ---
> You are currently subscribed to freetds as: [camber AT ais.org]
> To unsubscribe, forward this message to $subst('Email.Unsub')
>





Archive powered by MHonArc 2.6.24.

Top of Page