Sybase ASA Date Range ?

Brian Bruns camber at ais.org
Mon Apr 29 09:06:47 EDT 2002


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')
> 




More information about the FreeTDS mailing list