I am doing a project with SQL Server that contains datetime values that utilize the milliseconds. LLBL is working like a charm, of course.

In the near future I have to convert the database to oracle 9i. I am a little new at this platform, but I do know it has no millisecond (or fraction of a second) space in the datetime datatype. As result, I will need an extra column to hold the millisecond information in oracle.

Does anyone know of a way LLGL Gen Pro can allow or help me to treat two columns from a database as a single datetime with milliseconds field in an entity and typed list? This would be great because my code would not know the difference and require no changes.

Also, any suggestions on editing the generated code to "fix" this short fall of oracle?

Thanks in advance,

Darren

Which Oracle type did you look at particularly? Timestamp?

Timestamp maps to a .NET DateTime type, I'm not sure if Timestamp stores milliseconds though...

From doing some research, it looks like oracle 9i introduces TIMESTAMP and it supports milliseconds.

Thanks.

cool You can then use that column type then, and your own code won't change