Home
Help
Register
Log in

Search

 
   Active Threads  

You are here: Home > LLBLGen Pro > General> Oracle datetime - milliseconds and MS SQL
 

Pages: 1
General
Oracle datetime - milliseconds and MS SQL
Page:1/1 

  Print all messages in this thread  
Poster Message
Puromtec
User



Location:
MD
Joined on:
22-Jun-2005 16:38:52
Posted:
48 posts
# Posted on: 22-Jun-2005 16:48:57.  
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. Laugh

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

Thanks in advance,

Darren
  Top
Otis
LLBLGen Pro Team



Location:
The Hague, The Netherlands
Joined on:
17-Aug-2003 18:00:36
Posted:
34993 posts
# Posted on: 22-Jun-2005 17:33:29.  
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...


Frans Bouma
LLBLGen Pro / ORM Profiler Lead Developer | Blog | Twitter
 
Top
Puromtec
User



Location:
MD
Joined on:
22-Jun-2005 16:38:52
Posted:
48 posts
# Posted on: 22-Jun-2005 17:49:07.  
From doing some research, it looks like oracle 9i introduces TIMESTAMP and it supports milliseconds.

Thanks.
  Top
Otis
LLBLGen Pro Team



Location:
The Hague, The Netherlands
Joined on:
17-Aug-2003 18:00:36
Posted:
34993 posts
# Posted on: 22-Jun-2005 18:10:56.  
cool Regular Smiley You can then use that column type then, and your own code won't change Regular Smiley

Frans Bouma
LLBLGen Pro / ORM Profiler Lead Developer | Blog | Twitter
 
Top
Pages: 1  


Powered by HnD ©2002-2007 Solutions Design
HnD uses LLBLGen Pro

Version: 2.1.12172008 Final.