RE: Timestamp - to be or not to be?

From: Ruth Gramolini <rgramolini_at_tax.state.vt.us>
Date: Fri, 19 Mar 2004 13:31:48 -0500
Message-ID: <001601c40de0$705fabd0$8459699f@vttaxnet.tax.state.vt.us>

Some third party stuff, DBSurfer is one, can't handle timestamp. If you don't need that much specificity, I wouldn't use it.

Just my $.02,
Ruth

  -----Original Message-----
  From: oracle-l-bounce_at_freelists.org
  [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Mark Moynahan   Sent: Thursday, March 18, 2004 3:37 PM   To: oracle-l_at_freelists.org
  Subject: Timestamp - to be or not to be?

  Hi,

  Are there any technical reasons not to go forth with timestamp instead of   date datatype? Are there any gotcha's by converting to timestamp?

  If an application doesn't use fractions of a second is there any real need   to use timestamp datatype?

  Thanks,

  Mark

---

  Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

  To unsubscribe send email to: oracle-l-request_at_freelists.org   put 'unsubscribe' in the subject line.   --
  Archives are at http://www.freelists.org/archives/oracle-l/   FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

---

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

---

Received on Fri Mar 19 2004 - 12:27:37 CST