what if you really want to store the timestamp data, such as the publication d

what if you really want to store the timestamp data, such
as the publication date of the article?

Question Posted / amith

2 Answers
6031 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

what if you really want to store the timestamp data, such as the publication date of the article?..

Answer / tim little

A timestamp field can hold a date passed to it!
If you do :
CREATE TABLE newtable ( aname varchar(32), pubdate timestamp );
INSERT INTO newtable ( aname, pubdate ) values ( 'first', '2009-07-08' );
and then do a
SELECT * from newtable;

Then you get "2009-07-08 00:00:00" as the date back! You don't need a second field. Why do people think this? I've seen this all around the internet and it's always wrong!

Now, I will tell you that any updates to that ROW WILL clobber the field, UNLESS you make efforts to put the old value back in, like :
update newtable set aname = 'now', pubdate=pubdate where aname = 'first';

Is This Answer Correct ?

3 Yes

0 No

what if you really want to store the timestamp data, such as the publication date of the article?..

Answer / amith

Create two columns of type TIMESTAMP and use the second one
for your real data.

Is This Answer Correct ?

0 Yes

3 No

Post New Answer

More MySQL Interview Questions

Why mysql is open source?

0 Answers

Is sql and mysql same?

0 Answers

What is the difference between char and varchar?

0 Answers

What port is mysql running on?

0 Answers

How many columns can a mysql table have?

0 Answers

What is mysqlcommand?

0 Answers

in a master-master replication with two masters and alternate slaves running on two systems.can i have a script or any mysql command to know which one is right now acting as master.

1 Answers

What is “i_am_a_dump” flag in mysql?

0 Answers

what is cte? : Mysql dba

0 Answers

What is current version of mysql?

0 Answers

Is blocked because of many connection errors unblock with mysqladmin flush hosts?

0 Answers

Please suggest me any course and institute which provide training on the below skills. • Knowledge of data extraction concepts and tools • QMF (query management facility)queries • Experience and expertise in QMF queries • Excellent ability to write, read, and interpret QMF queries against the Source Data Warehouse base level (daily and monthly) and month-end affinity comp tables • RDBMS & ER • Knowledge of Relational Databases (RDBMS) and Entity Relationship (ER) Diagrams • SOURCE Data Warehouse • Experience and expertise in Source Data Warehouse or data warehouses on the mainframe. • MS SQL Server • Experience in MS SQL Server • Excellent skill in writing/interpreting SQL queries and running Data Transformation Services (DTS) or open query packages. • Knowledge of writing/interpreting Visual Basic code.

1 Answers

For more MySQL Interview Questions Click Here