那么怎么写成字符串呢? var sql:string; begin sql:='select * from db where time<'+????? 应该怎么写???
字符串?就用GETDATE()函数不就可以了么? 如果查询别的时间:sql='select * from db where time<'''+datetostr(xxxx)+'''' ;
看你用什么数据库? 如果是MS SQL Server的话,如果你的日期格式为美国制式,可以写成如下: sql:='select * from db where time<''8-2-2001''';
sql:='select * from db where time<getdate()'
var sSql:string; begin sSql='select * from db where time <''%s'''; Query1.SQL.Add(Format(sSql,[getdate()]); .....
和数据库 有关 sqlserver sql:='select * from db where time<''8-2-2001''' access sql:='select * from db where time<#8-2-2001#' paradox sql:='select * from db where time<"8-2-2001"'
var sql:string;
begin
sql:='select * from db where time<'+?????
应该怎么写???
如果查询别的时间:sql='select * from db where time<'''+datetostr(xxxx)+'''' ;
如果是MS SQL Server的话,如果你的日期格式为美国制式,可以写成如下:
sql:='select * from db where time<''8-2-2001''';
begin
sSql='select * from db where time <''%s''';
Query1.SQL.Add(Format(sSql,[getdate()]);
.....
sqlserver
sql:='select * from db where time<''8-2-2001'''
access
sql:='select * from db where time<#8-2-2001#'
paradox
sql:='select * from db where time<"8-2-2001"'