关于Access日期时间类型记录的问题(100分)

X

xcjp

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-03-27

• #1

Access中日期时间类型的记录在SQL中怎么写？
如我在BDE Administrator中输入一下语句：
insert into myTable (date) values ('1999-12-23 12:00:00')
通不过!

 

L

lizhongyi

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-03-27

• #2

insert into myTable(date) values ('#1999/12/23#')

 

G

GanQuan

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-03-27

• #3

insert into myTable(date) values (#12/23/1999#)

 

可

可儿

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-03-27

• #4

同意GanQuan

 

X

xcjp

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-03-27

• #5

接受答案了.