Normally I’ve always created my databases/tables/columns outside of Servoy but thought I’d try creating them inside of Servoy for a change. There are pluses and minuses with both but one thing I can’t figure out is if there is a way to have Servoy create a ‘DATE’ column as an Oracle ‘DATETIME’ column instead of a ‘TIMESTAMP’ column. I hardly ever want to use a TIMESTAMP column so I’d like the default to be DATETIME. Is there some preference where you can set that? Haven’t seen that in the docs but maybe I’m looking in the wrong place. I’d like to be able to set the precision and scale of number columns but that’s less important and is probably Oracle specific. Any pointers gratefully received!
I’m using PostgreSQL, so maybe it’s different from when Oracle is the back end – I see the DATETIME option within Servoy. This is with 5.x and 6.0.x. (Or maybe I’m not understanding the question.)
The problem is, when choosing ‘DATETIME’ as the column type when adding a column within Servoy, Servoy actually makes it a TIMESTAMP column in Oracle, not a DATE column (or DATETIME as it is in Oracle). This is in 5.2 but I believe in 6 and 6.1 as well.
Servoy does that to be as much compatible between different vendors of databases, there is not much you can do about that, than creating the column yourself, outside Servoy
Thanks Harjo. I was afraid of that. I think that might have been at least one of the reasons why I’ve always pretty much created my columns and tables with Aqua Data Studio instead. It is strange though when the vendor has both a datetime and a timestamp column type as Oracle does though that Servoy chooses timestamp. I guess perhaps every vendor has timestamp but not every vendor has datetime and so they have to go with timestamp?