What’s the difference between Unix timestamps and MySQL timestamps?

6 like 0 dislike

Hello
What’s the difference between Unix timestamps and MySQL timestamps?
please reply me. i am waiting for your reply.
Thanx

asked 1 year ago by eagles11 (179,830 points)

1 Answer

1 like 0 dislike

Best answer

Internally Unix timestamps are stored as 32-bit integers, while MySQL timestamps are stored in a similar manner, but represented in readable YYYY-MM-DD HH:MM:SS format.

answered 1 year ago by DBA-boss (120,990 points)

Related questions

4 like 0 dislike

2 answers

What is the difference between cat and more command in Unix?

asked 1 year ago by hunter (5,930 points)

7 like 0 dislike

1 answer

What is the difference between Swapping and Paging in unix?

asked 1 year ago by sr_webmaster (21,000 points)

4 like 0 dislike

1 answer

What’s the difference between CHAR_LENGTH and LENGTH?

asked 1 year ago by eagles11 (179,830 points)

4 like 0 dislike

0 answers

What’s the difference between a queue and a stack?

asked 1 year ago by marck_don (191,010 points)

4 like 0 dislike

0 answers

What's the difference between PageRank and Toolbar PageRank?

asked 1 year ago by eagles11 (179,830 points)