In mysql there is such a type as timestamp, but there is some kind of nonsense. Is it better to store the timestamp in fields with string type?

    2 answers 2

    With integer type

    • 3
      like this "online INT (11) DEFAULT 00000000000" - m0m0k0
    • A line is not better? - Jeremen1
    • five
      It would have been better - they would have answered "in the line is better", right? - user6550 September

    In MySQL, there is a timestamp in the types for the field, I'm afraid to guess what it is intended for :)

    • Did you yourself work with him? - Jeremen1
    • worked what you don't like about him? - tranceman pm
    • Well, according to the idea, time should be stored in UNIX format, and UNIX format is the number of seconds elapsed since the beginning of the UNIX era, but there you can insert certain numbers that give the same date, although logically even this is not possible. And the fact that generated by the time () function in PHP, that is, the normal UNIX format does not fit there at all ... - Jeremen1