what is timestamp in mysql? : Sql dba



what is timestamp in mysql? : Sql dba..

Answer / Priyam Upadhyay

In MySQL, a TIMESTAMP is a data type that stores both the date and time of an event. It automatically keeps track of the current date and time when you insert or update it. The default format for a TIMESTAMP is 'YYYY-MM-DD HH:MM:SS'. You can also set the value explicitly.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

What is the advantage of nosql?

1 Answers  


What does an inner join do?

1 Answers  


What are types of indexes in sql?

1 Answers  


What is data type in sql?

1 Answers  


what does myisamchk do? : Sql dba

1 Answers  


What is 19 null in sql?

1 Answers  


what is difference between decode and case function?

2 Answers  


How to use sql*plus built-in timers?

1 Answers  


Explain the difference between sql and mysql.

1 Answers  


What is compute?

1 Answers  


What is mutating error?

1 Answers  


What are the different types of dbms?

1 Answers  


Categories