freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
- 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')
>
-
Sybase ASA Date Range ?,
jekend, 04/29/2002
- <Possible follow-up(s)>
- Re: Sybase ASA Date Range ?, Brian Bruns, 04/29/2002
- Re: Sybase ASA Date Range ?, Coleman, Dave, 04/29/2002
- Re: Sybase ASA Date Range ?, Lowden, James K, 04/29/2002
- Re: Sybase ASA Date Range ?, Brian Bruns, 04/29/2002
- Re: Sybase ASA Date Range ?, Bill Thompson, 04/30/2002
Archive powered by MHonArc 2.6.24.