Re: mysql create table with date or timestamp

If you need date and hour the best way is: CREATE TABLE diary ( iddiary int auto_increment not null, imepriimek varchar(50), when timestamp, action varchar(30), onfile varchar(100) unique id(iddiary) ); if you need only date you can use: CREATE TABLE diary ( iddiary int auto_increment not null, imepriimek varchar(50), when date, action varchar(30), onfile varchar(100) unique id(iddiary) ); To get formated date you should use: select date_format(when, "%T%W%e%c%y") from diary; To put data in this field you can use: insert into diary (when) values (str_to_date("10:55:14Thursday28509", "%T%W%e%c%y")); -- João Cândido de Souza Neto SIENS SOLUÇÕES EM GESTÃO DE NEGÓCIOS Fone: (0XX41) 3033-3636 - JS www.siens.com.br "Grega Leskovsek" <mavricek@gmail.com> escreveu na mensagem news:1df2d4810905280643y62a0f092p91fa2c57558d86d7@mail.gmail.com... > 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