Re: Re: mysql create table with date or timestamp

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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



[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux