Not signed in (Sign In)

Vanilla 1.1.4 is a product of Lussumo. More Information: Documentation, Community Support.


Archive: phpmyadmin and timestamp

Bottom of Page

1 to 3 of 3

  1.  
    • CommentAuthorviane
    • CommentTimeFeb 1st 2007
     
    How can I set the format of a timestamp filed? Whatever I do I again get default "0000-00-00 00:00:00" which I don't want.

    I wonder if this is a problem with phpmyadmin or mysql.
    • CommentAuthorkevin
    • CommentTimeFeb 1st 2007
     
    That's how MySQL stores DATETIME types - you could use and INT(11) and store the Unix timestamp.
    But why don't you like the DATETIME type?!? What are you trying to do?
    • CommentAuthorviane
    • CommentTimeFeb 1st 2007
     
    OK, thanks.
    I just thought a numeric timestamp would be better for consistency.

1 to 3 of 3

  1.