sybase datediff mysql_sybase的datediff问题

用datediff怎么编都编不过去，程序里面是这么写的execsqlselectdatediff(t,"2000-10-10","2010-10-20")into：t;就是sql语句，我用的是unix环境+sybase数据库，错误如下：ld:0711-317E...

用datediff怎么编都编不过去，程序里面是这么写的exec sql select datediff(t,"2000-10-10","2010-10-20") into ：t;就是sql语句，我用的是unix环境+sybase数据库，错误如下：

ld: 0711-317 ERROR: Undefined symbol: .datediff

ld: 0711-317 ERROR: Undefined symbol: ._sqlinitctx

ld: 0711-317 ERROR: Undefined symbol: ._sqlprolog

ld: 0711-317 ERROR: Undefined symbol: ._sqlepilog

ld: 0711-317 ERROR: Undefined symbol: ._sqlctdiag

ld: 0711-317 ERROR: Undefined symbol: ._sqlsetintrerr

ld: 0711-317 ERROR: Undefined symbol: ._sqlcheckstr

ld: 0711-317 ERROR: Undefined symbol: ._sqlResults

求解释啊.......

求sybase数据库高手！！！！！！！

我的程序是这么写的

int main()

{

exec sql begin declare section;

int t;

exec sql end declare section;

exec sql select datediff(d,"2010/10/10","2010/10/12") as t ;

if(sqlca.sqlcode !=0)

{printf("datediff failed\n");}

printf("t=%d\n",t);return 0;

}

程序的执行结果是datediff failed 就是执行失败了、怎么解决呢

展开