Hi!
On Aug 12, 2008, at 5:11 AM, Erik Wetterberg wrote:
TIMESTAMP has a valid range of only '1970-01-01 00:00:01' UTC to
'2038-01-09 03:14:07'. This makes it not a good datatype for new
systems, since 2038 is actually not so far away...
I have a hope to have a better solution in twenty years :)
The main benefit to TIMESTAMP is that it is currently cheap... it is
just 8bytes. Innodb handles it as 8bytes and unless that group wants
to step forward... changing it is a real pain.
Have any ideas on how to get more life out of it?
The important difference between DATETIME and TIMESTAMP is that
TIMESTAMP columns (in MySql) offers automatic initialization and
updating. The rules for this are not easy:
(http://dev.mysql.com/doc/refman/5.1/en/timestamp.html)
Please suggest new rules. I would hope that someone would be up for
modifying it.
work. Does this mean that timestamp columns will always be updated as
records are changed and inserted? Or that this functionality will be
dropped so that timestamp columns will work like DATETIME columns?
I see no reason to have TIMESTAMP unless they automatically update.
If you want to set a time, just use DATETIME.
Cheers,
-Brian
Erik Wetterberg
On Tue, Aug 12, 2008 at 9:55 AM, Roy Lyseng <[EMAIL PROTECTED]>
wrote:
Brian Aker wrote:
Hi!
On Aug 12, 2008, at 12:28 AM, Roy Lyseng wrote:
why do you need both TIMESTAMP and DATETIME?
TEXT should be named CLOB to be aligned with SQL standard...
I am up for whatever folks want here. TEXT has always been the
MySQL type.
I do not mind using the standard type name (or aliasing it).
If there is a standard, why not use it? Especially one that is so
comprehensive and consistent as the SQL standard (for most parts) :)
Roy
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-discuss
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-discuss
More help : https://help.launchpad.net/ListHelp
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-discuss
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-discuss
More help : https://help.launchpad.net/ListHelp
--
_______________________________________________________
Brian "Krow" Aker, brian at tangent.org
Seattle, Washington
http://krow.net/ <-- Me
http://tangent.org/ <-- Software
_______________________________________________________
You can't grep a dead tree.
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-discuss
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-discuss
More help : https://help.launchpad.net/ListHelp
