Thomas S

Thomas S

  • NA
  • 6
  • 0

Access DateTime Insert

Sep 3 2008 4:34 AM

Hi,

i tryed to insert with the following sql syntax:

"INSERT INTO Mail(betreff,inhalt,timestamp) values('asdf','asdf',#2008-09-03 13:27#)"

but it doesnt work.

If i remove the timestamp (insert into mail(betreff,inhalt)...) it works.

What is wrong with the TimeStamp? Access says its a syntax error.

 

Regards,

Thomas


Answers (1)