Interested to Buy Any Domain ? << Click Here >> for more details...
what if you really want to store the timestamp data, such
as the publication date of the article?
- 2 Answers
- 6033 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Restore database (or database table) from backup.
How can you create and drop view in mysql?
What are the drivers in MySQL?
What is deterministic in mysql?
How do I delete a row in mysql?
Does mysql support nosql?
How do I select a database in mysql workbench?
Why MySQL is used?
How many rows can mysql handle?
Explain the difference between primary key and candidate key in mysql?
What is dblink?
How can we get total number of records by query in mysql?
How do I install mysql on windows 7?
What is information_schema in mysql?
Can foreign key have duplicate values?
