phpmyadmin and timestamp

Discussion in 'MySQL' started by mahmood, Jan 29, 2007.

0
  1. #1
    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.
     
    mahmood, Jan 29, 2007 IP
  2. picouli

    picouli Peon

    Messages:
    760
    Likes Received:
    89
    Best Answers:
    0
    Trophy Points:
    0
    #2
    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?
     
    picouli, Jan 29, 2007 IP
    mahmood likes this.
  3. mahmood

    mahmood Guest

    Messages:
    1,228
    Likes Received:
    43
    Best Answers:
    0
    Trophy Points:
    0
    #3
    OK, thanks.
    I just thought a numeric timestamp would be better for consistency.
     
    mahmood, Jan 29, 2007 IP