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.

List some comparisons operators used in mysql?

0 Answers  

---

How can you see all indexes defined for a table?

0 Answers  

---

SELECT country,city FROM customers GROUP BY country ORDER BY city DESC

5 Answers   HCL,

---

What is pdo connection?

0 Answers  

---

What is the datatype for password in mysql?

0 Answers  

---

How to use case expression?

0 Answers  

---

How do I drop a database in mysql?

0 Answers  

---

How to get the number of rows selected or affected by a sql statement?

0 Answers  

---

What is definer in mysql trigger?

0 Answers  

---

Is mysql distributed?

0 Answers  

---

For the database from the previous question, please give an SQL query which returns the invoice number of all invoices which contain the article with the number ?1234?. The query should be able to run under a MySQL 4.0 database.

1 Answers  

---

What is a user defined variable?

0 Answers  

---