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
- 5817 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
Is mysql frontend or backend?
What happens if you no create privilege in a database?
Restore database (or database table) from backup.
What is a csv table?
What is use of mysql?
Is mysql server free?
how to add a new column to an existing table?
How to upload a large file through phpmyadmin in mysql?
What language is used in mysql?
What is a result set object?
What are numeric data types?
How do I rename a table in mysql workbench?
How to use rank function in mysql?
What are slow queries?
How do I select a database in mysql workbench?
