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" <[email protected]> escreveu na mensagem
news:[email protected]...
> 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
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
