mysql create table with date or timestamp
| From: | Grega Leskovsek | Date: | Thu, 28 May 2009 13:43:42 +0000 |
| Subject: | mysql create table with date or timestamp | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-293291@lists.php.net to get a copy of this message | ||
CREATE TABLE diary(iddiary int auto_increment not null, imepriimek
varchar(50), when date("%T%W%e%c%y"), action varchar(30), onfile
varchar(100) unique id(iddiary));
I tried the above and it didn't work. What must I do to create a table
with full time and date. If I should use timestamp how do I convert
thee timestamp in php back to "normal" time? (I also tried the mysql
command:
when timestamp
and
when date
in the above first mysql clause but it didnt work
)
Please help me. Thanks in advance,
--
When the sun rises I receive and when it sets I forgive ->
http://users.skavt.net/~gleskovs/
All the Love, Grega Leskov'sek