//添加记录至借阅信息
str:='insert into 借阅信息(会员编号,店内编号,借出日期,是否归还) ';
str:=str+'values('+format('%0.10d',[strtoint(rennu)])+',';
str:=str+format('%0.10d',[strtoint(booksh)])+',';
str:=str+formatdatetime('yyyy-mm-dd',now)+','; //这一行
str:=str+''''+'否'+''''+')';
adocommand1.CommandText :=str;
adocommand1.Execute;为什么用以上语句输入数据库的是1905-6-19
windows XP 系统当前时间为2003-2-04
str:='insert into 借阅信息(会员编号,店内编号,借出日期,是否归还) ';
str:=str+'values('+format('%0.10d',[strtoint(rennu)])+',';
str:=str+format('%0.10d',[strtoint(booksh)])+',';
str:=str+formatdatetime('yyyy-mm-dd',now)+','; //这一行
str:=str+''''+'否'+''''+')';
adocommand1.CommandText :=str;
adocommand1.Execute;为什么用以上语句输入数据库的是1905-6-19
windows XP 系统当前时间为2003-2-04
Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
Dialogs, StdCtrls;type
TForm1 = class(TForm)
Button1: TButton;
procedure Button1Click(Sender: TObject);
procedure FormCreate(Sender: TObject);
private
{ Private declarations }
public
{ Public declarations }
end;var
Form1: TForm1;implementation{$R *.dfm}procedure TForm1.Button1Click(Sender: TObject);
var
myDateTime : TDateTime;
begin
MyDateTime := Date;
Showmessage(DateToStr(MyDateTime));
end;end.
grail_(grail_) 的方法显示的是1899-12-30我快要崩溃了,谁来救救我!!!!!!!!!!!!!
TimeToStr(Time())
TO_DATE('sysdate(string)','yyyy-mm-dd hh:mi:ss')函数
(to_date('date','yyyy-mm-dd')
or to_date('time','hh:mi:ss'));
ACCESS最好就直接在数据库中定义该字段类型为文本型!
sql server没有插过,但是好象不能直接对日期或者时间进行筛选!
int(date); //获取系统日期 edit1.Text :=datetimetostr(int(date));
int(now); //获取系统日期和时间
把2003-02-04变成1997了,它自己给减了,我疯了!!!!!!!
把2003-02-04变成1997了,它自己给减了
str:='insert into 借阅信息(会员编号,店内编号,借出日期,是否归还) ';
str:=str+'values('+format('%0.10d',[strtoint(rennu)])+',';
str:=str+format('%0.10d',[strtoint(booksh)])+',';
str:=str+''''; //加入前引号
str:=str+formatdatetime('yyyy-mm-dd',now);
str:=str+''''; //加入后引号,即用引号将时间括起来
str:=str+',';
str:=str+''''+'否'+''''+')';
adocommand1.CommandText :=str;
adocommand1.Execute;