what if you really want to store the timestamp data, such
as the publication date of the article?

Answer Posted / amith

Create two columns of type TIMESTAMP and use the second one
for your real data.

Is This Answer Correct ?    0 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the phantom problem?

485


In a property booking section want a query to check that property is booked from StartDate to EndDate.Booking Table field are given id proerty_id start_date checkout_date no_of_visitor booking date status Waiting yours answer.. Thanks In Advance...

2564


Is blocked because of many connection errors unblock with mysqladmin flush hosts?

485


How to use count function in mysql?

471


What is int unsigned?

487






How do we delete a row in a table?

523


What is mysql and why it is used?

548


Why do we use the mysql database server?

520


Can we rollback truncate in mysql?

505


How do I create a database in mysql workbench?

433


What is difference between function and procedure in mysql?

443


Write a command to list all databases in mysql?

518


If you are assigned a task, to find the information of procedures. What are the basic commands that you will use to do so?

491


Is blocked because of many connection errors mysql?

426


How do I clear the command in mysql?

481