Aktuelles Datum in die DB speichern?

[Aphton]

Zitat von OrNEC:

Zitat von Aphton:

Benütze bitte Format(), bitte!

Du meinst Format(Date("now"))?

Bringt auch nix...

Nein...

Delphi-Quellcode:

const
  queryInsertMedia = 
    'INSERT INTO media (mediatitle, description, status, isbn, publicationyear, insertdate, fk_place_id, fk_publisher_id, fk_author_id, fk_category_id, fk_language_id, fk_entleiher_id, edition) ' +
    'VALUES ("%s", "%s", "%s", "%s", "%s", "%s", "%s", "%s", "%s", "%s", "%s", "%s", "%s")';

{...}

sSql := Format(queryInsertMedia, [TitleEdit.Text, DescriptionMemo.Text, IntToStr(status), {...}]);

Edit:
Format(Date("now"))
"??
Delphi-Syntax!