DDC-66: missing column type "timestamp" #77

Closed
opened 2026-01-22 12:26:20 +01:00 by admin · 3 comments
Owner

Originally created by @doctrinebot on GitHub (Oct 27, 2009).

Originally assigned to: @jwage on GitHub.

Jira issue originally created by user chriswest:

The former supported column type "timestamp" is not defined in Doctrine\DBAL\Types\Type.

Patches and suggestions follow.

Originally created by @doctrinebot on GitHub (Oct 27, 2009). Originally assigned to: @jwage on GitHub. Jira issue originally created by user chriswest: The former supported column type "timestamp" is not defined in Doctrine\DBAL\Types\Type. Patches and suggestions follow.
admin added the Bug label 2026-01-22 12:26:20 +01:00
admin closed this issue 2026-01-22 12:26:21 +01:00
Author
Owner

@doctrinebot commented on GitHub (Oct 27, 2009):

Comment created by romanb:

See DDC-64 for where best to patch this.

@doctrinebot commented on GitHub (Oct 27, 2009): Comment created by romanb: See [DDC-64](http://www.doctrine-project.org/jira/browse/DDC-64) for where best to patch this.
Author
Owner

@doctrinebot commented on GitHub (Oct 29, 2009):

Comment created by chriswest:

I think you need another type "Timestamp". Otherwise you cannot decide if it should be mapped to a "DATETIME" or "TIMESTAMP" column in mysql. A timestamp column only requires 4 bytes of storage space - datetime requires 8 bytes, so this is quite a decision regarding performance and storage space. a timestamp, of course, is limited to a date range. see http://dev.mysql.com/doc/refman/5.0/en/storage-requirements.html

I see that in D1 you mapped "timestamp" to "DATETIME". To be fully backwards compatible, a timstamp should be converted to a D2 "DateTime" type then (in this case ignore the first paragraph of this comment :)).

@doctrinebot commented on GitHub (Oct 29, 2009): Comment created by chriswest: I think you need another type "Timestamp". Otherwise you cannot decide if it should be mapped to a "DATETIME" or "TIMESTAMP" column in mysql. A timestamp column only requires 4 bytes of storage space - datetime requires 8 bytes, so this is quite a decision regarding performance and storage space. a timestamp, of course, is limited to a date range. see http://dev.mysql.com/doc/refman/5.0/en/storage-requirements.html I see that in D1 you mapped "timestamp" to "DATETIME". To be fully backwards compatible, a timstamp should be converted to a D2 "DateTime" type then (in this case ignore the first paragraph of this comment :)).
Author
Owner

@doctrinebot commented on GitHub (Nov 11, 2009):

Issue was closed with resolution "Fixed"

@doctrinebot commented on GitHub (Nov 11, 2009): Issue was closed with resolution "Fixed"
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: doctrine/archived-orm#77