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';

Answer / amith

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

What is the storage engine used for MySQL?

1 Answers  

---

How do I make an action query?

0 Answers  

---

How we can get distinct columns values in mysql?

0 Answers  

---

What is database migration in mysql?

0 Answers  

---

How to set the time zone for MySQL to particular country time?

0 Answers  

---

How many triggers are possible in mysql?

0 Answers  

---

In which year mysql created?

0 Answers  

---

How large can a mysql table be?

0 Answers  

---

Which is faster mysql or mongodb?

0 Answers  

---

Consider you have the following three tables which have to be linked together.

0 Answers  

---

What is the difference between MyISAM Static and MyISAM Dynamic?

0 Answers  

---

How do I edit a database in mysql workbench?

0 Answers  

---