adspace


what is timestamp in mysql? : Sql dba

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

Can delete statement be rollbacked?

1065


how many tables will create when we create table, what are they? : Sql dba

1154


what is dbms? : Sql dba

1069


how to escape special characters in sql statements? : Sql dba

1124


Is primary key always clustered index?

1101


What is the best sql course?

1062


how to start mysql server? : Sql dba

1279


how to use regular expression in pattern match conditions? : Sql dba

1125


Can we use distinct and group by together?

1146


what is sql server agent? : Sql dba

1188


Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

2099


Is primary key clustered index?

1026


what are all the common sql function? : Sql dba

1141


If a cursor is open, how can we find in a pl/sql block?

1252


Does group by remove duplicates?

1120