ORM and Dates? You probably want timestamp

Posted At : November 22, 2010 5:05 PM | Posted By : Sam Farmer
Related Categories: ORM, ColdFusion 9.0.1, ColdFusion 9

Data types for dates and times are slightly different across databases which often makes life difficult for us developers. ColdFusion ORM makes this pretty simple:

For a date with time use ormtype="timestamp"
Just a date use ormtype="date"

There are no other options!

Full example with the property tag:

view plain print about

1property name="aFullDateWithTime" ormtype="timestamp";
2property name="justADate" ormtype="date";

Comments (2) |

Print |

Related Blog Entries

Using ORM Event Handler to easily and automatically add audit information (January 23, 2010)

Comments (Comment Moderation is enabled. Your comment will not appear until approved.)

Add Comment Subscribe to Comments

How would I create a MS SQL TimeStamp though?????

# Posted By Darrin | 3/28/12 9:45 AM

Several options:

You can set the database to use timestamp on the column.

You can use the optimistic locking:
http://help.adobe.com/en_US/ColdFusion/9.0/Develop...
And set
property name="lastModified" fieldtype="timestamp";

You could also look into the DDL options:
http://help.adobe.com/en_US/ColdFusion/9.0/Develop...

# Posted By Sam Farmer | 3/28/12 10:07 AM

Add Comment