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
- 5914 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
What is mysql cursor?
What are mysql queries?
Consider a scenario where you have two to three tables with thousand tuples in each of them. Now, if you have to perform a join operation between them will you choose to perform filtering of rows or transforming of rows first.
What is pdo in mysql?
What is memory table in mysql?
What is the maximum size of mysql database?
Explain the different types of mysql joins.
What is the maximum no of columns a table can have?
What is the storage engine for mysql?
Does mysql automatically index foreign keys?
How to extract a unit value from a date and time?
How to create a table index in mysql?
What does mysql_fetch_assoc do?
How do I backup mysql database on linux?
what is the difference between the nvl function, ifnull function, and the isnull function? : Mysql dba
