I GOT THIS ERROR when I tried first sample with when timestamp;
ERROR 1064 (42000): You have an error in your SQL syntax; check the
manual thatcorresponds to your MySQL server version for the right
syntax to use near 'id(iddiary) )' at line 1
2009/5/28 João Cândido de Souza Neto <joao@xxxxxxxxxxxxxxxxxxx>:
> 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)
> );
Please advice. Thanks in advance, Grega
>
> 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@xxxxxxxxx> escreveu na mensagem
> news:1df2d4810905280643y62a0f092p91fa2c57558d86d7@xxxxxxxxxxxxxxxxx
>> 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
>
>
--
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
