What Is The Difference Between Unix Timestamps And Mysql Timestamps?

1.	What Is The Difference Between Unix Timestamps And Mysql Timestamps?
Answer» ACTUALLY both UNIX TIMESTAMP and MySQL timestamp are stored as 32-bit integers but MySQL timestamp is represented in readable format of YYYY-MM-DD HH:MM:SS format. Actually both Unix timestamp and MySQL timestamp are stored as 32-bit integers but MySQL timestamp is represented in readable format of YYYY-MM-DD HH:MM:SS format.

Answer»

ACTUALLY both UNIX TIMESTAMP and MySQL timestamp are stored as 32-bit integers but MySQL timestamp is represented in readable format of YYYY-MM-DD HH:MM:SS format.

Actually both Unix timestamp and MySQL timestamp are stored as 32-bit integers but MySQL timestamp is represented in readable format of YYYY-MM-DD HH:MM:SS format.

Discussion

No Comment Found

Related InterviewSolutions

What Is Sqlyog?
How Do You Backup A Database In Mysql?
What Are The Differences Between Mysql_fetch_array(), Mysql_fetch_object(), Mysql_fetch_row()?
What Are The Advantages Of Myisam Over Innodb?
What Is The Usage Of Enums In Mysql?
How Is Myisam Table Stored?
What Is The Use Of Mysql_close()?
What Is Mysql Data Directory?
How Do You Determine The Location Of Mysql Data Directory?
What Is The Usage Of Regular Expressions In Mysql?

What Is The Difference Between Unix Timestamps And Mysql Timestamps?

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment