Hi Pambos,
you can use the function date in this manner:
date("YmdGis");
because the type TIMESTAMP has the following format:
YYYYMMDDHHMMSS, where:
YYYY=year like 2004
MM=month like 04
DD=day like 24
HH=hour like 10
MM=minutes like 24
SS=seconds like 33
in this case date("YmdGis"); has the output 20040424102433 that is the right
format for TIMESTAMP.
----- Original Message -----
From: "Pambos Nicolaou" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, April 24, 2004 6:35 AM
Subject: [PHP-DB] Inserting date into a table
> I have created the table below:
>
> CREATE TABLE questions (ID INT NOT NULL AUTO_INCREMENT,name
VARCHAR(30),day
> TIMESTAMP, question TEXT, email VARCHAR(30),answer TEXT, PRIMARY KEY(ID));
>
> I want to insert into the TIMESTAMP field the date automatically. How can
I
> do it using the insert command
>
> "INSERT INTO $table
> VALUES('','$name','TIMESTAMP','$question','$email','NULL')";
>
> Thanks in advance
>
> Pambos Nicolaou
>
> _________________________________________________________________
> Protect your PC - get McAfee.com VirusScan Online
> http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
