[TORQUE-11] Torque Type Timestamp should be mapped to datetime in Mysql

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.3
• Fix Version/s: 4.0-beta1
• Component/s: Generator, Runtime
• Environment: Mysql
• Old Scarab Id: TRQS298
• Assignee: Thomas Fox
• Reporter: Thomas Fox
• Created: 01/May/06 23:02
• Updated: 24/Sep/12 07:06
• Resolved: 17/Jan/12 01:45

Description

Currently, the torque type timestamp is mapped to timestamp in mysql. However, timestamp in mysql has a range only from 1970 to 2037, whereas datetime has a range from 1000 to 9999. Both seem to have second precision. Thanks to Joerg Friedrich for suggesting this.