Skip to Content.
Sympa Menu

freetds - Sybase ASA Date Range ?

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "jekend" <wangjg AT ec-server.com>
  • To: freetds AT franklin.oit.unc.edu
  • Subject: Sybase ASA Date Range ?
  • Date: Mon, 29 Apr 2002 05:14:23 -0400


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 ?





Archive powered by MHonArc 2.6.24.

Top of Page