Re: Yet another question about date and time
Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance
Date: Fri, 5 Mar 2004 06:21:05 -0800
I guess you are an Oracle guy.
SQL doesn't have a TIME data type, although it might appear in "Yukon".
At least SQL Server has a more sensible "earliest" date than Oracle :-D
Relevant Pages
- Re: Is Interbase still thriving?
... With Yukon, Oracle and IBM are ... I have used Oracle, Interbase, as well. ... SQL Server and MS Access for desktop application. ... I used to work on VMS / and OpenVMS from DEC. ... (borland.public.delphi.non-technical) - Re: Is Interbase still thriving?
... "Even Oracle is afraid of Yukon" LOL. ... SQL Server and MS ACCESS everyday to know well ... Yukon will redefine RDBMS market. ... >The battle at the top won by MSSQL? ... (borland.public.delphi.non-technical) - Re: IOT, memory and transaction time
... easily generate it with DBMS_METADATA.GET_DDL if your verison of Oracle ... were pretty consistent no matter how big the table (this transaction ... FOREIGN KEY (versionNo) REFERENCES T_TRANSACTIONS, ... Oracle provides read consistency and SQL Server ... (comp.databases.oracle.misc) - Re: Database or store to handle 30 Mb/sec and 40,000 inserts/sec
... "Writers block readers and readers block writers in SQLServer. ... getting around this fundamental issue and because of it SQL Server ... admitted they can happen in Oracle, I guess Oracle should never been used ... isolation level but you will always disagree because you follow doctorine ... (comp.databases.oracle.server) - Re: IOT, memory and transaction time
... easily generate it with DBMS_METADATA.GET_DDL if your verison of Oracle ... If it was the update statement that references ... FOREIGN KEY (versionNo) REFERENCES T_TRANSACTIONS, ... There are however differences how both products deal with concurrency; in Oracle readers don't get blocked while this may happen in SQL Server. ... (comp.databases.oracle.misc) |
|