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