<div>
Depends on how you defined the field - but, by default, yes. &nbsp;A single TIMESTAMP field functions, by default, as a &quot;modified date/time&quot; field if you don't give it a value.<br />
<br />
You can change that functionality a number of ways, though:<br />
<a href="http://dev.mysql.com/doc/refman/5.0/en/timestamp-initialization.html" rel="ugc">http://dev.mysql.com/doc/refman/5.0/en/timestamp-initialization.html</a>
</div>


Depends on how you defined the field - but, by default, yes.  A single TIMESTAMP field functions, by default, as a "modified date/time" field if you don't give it a value.

You can change that functionality a number of ways, though:
http://dev.mysql.com/doc/refman/5.0/en/timestamp-initialization.html [http://dev.mysql.com/doc/refman/5.0/en/timestamp-initialization.html]

<div>
Sorry, missed the last bit there: yes, it functions basically as a DATETIME. &nbsp;Only key difference is that it'll convert from the defined local timezone to UTC for storage, and then back to the local timezone for retrieval.
</div>


Sorry, missed the last bit there: yes, it functions basically as a DATETIME.  Only key difference is that it'll convert from the defined local timezone to UTC for storage, and then back to the local timezone for retrieval.

<div>
To slinkygn<br />
<br />
So it will also modify the timestamp if I update the row?<br />
<br />
I don't want that.
</div>


To slinkygn

So it will also modify the timestamp if I update the row?

I don't want that.

<div>
As was stated in the link I included.
</div>


<div>
<div class="content wysiwyg-content">
Based on what I've read of this, I'm guessing that if a timestamp is included as a field in a table &amp;&nbsp;a record is inserted into that table, the value of the field is set to the then current date &amp;&nbsp;time (server time) to the nearest second. I'm guessing that you DO NOT include any &quot;value&quot; for the timestamp field.<br />
<br />
Of course I'm assuming I can report that value like a datetime.<br />
<br />
Is this correct?<br />
<br />
Thanks
</div>
</div>


Based on what I've read of this, I'm guessing that if a timestamp is included as a field in a table & a record is inserted into that table, the value of the field is set to the then current date & time (server time) to the nearest second. I'm guessing that you DO NOT include any "value" for the timestamp field.

Of course I'm assuming I can report that value like a datetime.

Is this correct?

Thanks

MySQL timestamp data type

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.