|
| Re: Does MySql have a timestamp type that works like SQL Server's? |
 |
Mon, 31 Mar 2008 14:16:59 +000 |
I don't think that will work because the auto update feature resolves to 'Now()'
which is of the following format... 'YYYY-MM-DD HH:MM:SS'
So I suspect that if two updates happen within the same second, the timestamp
column will get the same value twice. With SQL Server's timestamp however,
there'd be two unique values.
|
| Post Reply
|
| Does MySql have a timestamp type that works like SQL Server's? |
 |
Mon, 31 Mar 2008 14:20:52 +000 |
Hi,
In SQL Server one can have a column of type timestamp which results in a value
that's automatically updated whenever the row to which it belongs to is updated.
The value doesn't actually correspond to valid date.
Does MySql have this feature?
Cheers, Ian.
|
| Post Reply
|
| Re: Does MySql have a timestamp type that works like SQL Server's? |
 |
Mon, 31 Mar 2008 14:52:29 +000 |
Yes.
http://dev.mysql.com/doc/refman/5.0/en/date-and-time-types.html
|
| Post Reply
|
|
|
|
|
|
|
|
|
|