This thread looks to be a little on the old side and therefore may no longer be relevant. Please see if there is a newer thread on the subject and ensure you're using the most recent build of any software if your question regards a particular product.
This thread has been locked and is no longer accepting new posts, if you have a question regarding this topic please email us at support@mindscape.co.nz
|
Hi, When setting the Data Type of an entity property to "DateTime" for a Postgres database, LightSpeed generates the column with the Date data type which does not capture the time. Shouldn't it use the "timestamp" data type? The same happens for the autogenerated columns using Track Create Time, Track Update Time and Soft Delete. I'm using a nightly build from 20090812. Thanks Peter |
|
|
You're right, timestamp would be better. I've made this change and it will be included in nightly builds dated 3 Sep 2009 and above. |
|
|
Just as an addendum, this will not change the data type of any already created DATE columns in the database. You will need to change those by hand, or delete them and have the designer recreate them for you. |
|