SQL datetime ERROR !
| From: | Djurovski Dejan | Date: | Tue, 13 Aug 2002 20:16:52 +0000 |
| Subject: | SQL datetime ERROR ! | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-112423@lists.php.net to get a copy of this message | ||
Hi,
I use this query to input data into MySQL DB.
EXPIRE is Expire Date!
My script allways inputs "1.1.0001" into database (as value of expire).
what is wrong?
My table:
CREATE TABLE korpa (
idnarudzbeukorpi int(255) DEFAULT '0' NOT NULL auto_increment,
mernaj varchar(255) NOT NULL,
nazivproizvoda varchar(255) NOT NULL,
ip_adresa_narucioca varchar(255) NOT NULL,
id_proizvoda varchar(255) NOT NULL,
kolicina_proizvoda decimal(255,2) DEFAULT '1.00' NOT NULL,
cena decimal(255,2),
datum datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
expire datetime,
PRIMARY KEY (idnarudzbeukorpi)
);
MySQL query:
$aSQL2="insert into korpa (mernaj, nazivproizvoda, ip_adresa_narucioca,
id_proizvoda, cena, datum, expire) values ('$mernaj', '$naziv', '$ip',
'$id', '$cena', now(), now()+3000)";
Please help me!
----------------------
----------------------
Djurovski Dejan
dejanyu@eunet.yu