Groups > Databases > MySQL for ASP.NET > Re: Does MySql have a timestamp type that works like SQL Server's?




Re: Does MySql have a timestamp type that works like SQL
Server's?

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
about | contact