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.

How do you know the version of your mysql server?

0 Answers  

---

What is the difference between the DELETE TABLE and TRUNCATE TABLE commands in MySQL?

1 Answers  

---

how we connect the data base in any programme

2 Answers  

---

how to connect a php script with the mysql database?

0 Answers  

---

How do I know if mysql is installed on windows?

0 Answers  

---

What is the function of myisamchk?

0 Answers  

---

What is the difference between unix timestamp and mysql timestamp?

0 Answers  

---

Write a query to select all teams that won either 1, 3, 5 or 7 games.

0 Answers  

---

Do while loop in mysql procedure?

0 Answers  

---

What is the difference between mysql_fetch_assoc and mysql_fetch_array?

0 Answers  

---

What is mysql used for?

0 Answers  

---

How do you login to MySql using Unix shell?

0 Answers  

---