Re: Yet another question about date and time

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Al (al_davie_at_hotmail.com)
Date: 03/05/04


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)