RE: Timestamp - to be or not to be?

  • From: "Ruth Gramolini" <rgramolini@xxxxxxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 19 Mar 2004 13:31:48 -0500

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@xxxxxxxxxxxxx
  [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Mark Moynahan
  Sent: Thursday, March 18, 2004 3:37 PM
  To: oracle-l@xxxxxxxxxxxxx
  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@xxxxxxxxxxxxx
  put 'unsubscribe' in the subject line.
  --
  Archives are at //www.freelists.org/archives/oracle-l/
  FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: