Re: 2 Questions - DateTime fractional seconds and Transactions

2004-07-15 Thread Paul DuBois
At 10:54 -0700 7/15/04, Tom Kirkman wrote: 1. Though I was not able to find it explicitly stated in the online manual, I'm inferring from what I did find that the server v4.1.3 Win32 cannot store fractions of a second in DateTime columns (though oddly enough, several existing DataTime functions do

Re: 2 Questions - DateTime fractional seconds and Transactions

2004-07-15 Thread Martijn Tonies
Hi Tom, === 2. Will an ADO sqlTransaction that is begun but not explicitly committed or rolled back (i.e. the session was terminated before the transaction could be concluded) be automatically rolled back or automatically committed by the server? === This question has a rather high "duh" factor

2 Questions - DateTime fractional seconds and Transactions

2004-07-15 Thread Tom Kirkman
1. Though I was not able to find it explicitly stated in the online manual, I'm inferring from what I did find that the server v4.1.3 Win32 cannot store fractions of a second in DateTime columns (though oddly enough, several existing DataTime functions do handle them). It was stated that support f