From oracle-l-bounce@freelists.org Fri Mar 19 12:27:37 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i2JIRbL21127 for ; Fri, 19 Mar 2004 12:27:37 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i2JIRbo21122 for ; Fri, 19 Mar 2004 12:27:37 -0600 Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id CCE9B390C1A; Fri, 19 Mar 2004 13:25:32 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Fri, 19 Mar 2004 13:24:28 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from mx1.state.vt.us (ns1.lib.vt.us [159.105.23.130]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id B8C90390A14 for ; Fri, 19 Mar 2004 13:24:27 -0500 (EST) Received: from TAX132 ([159.105.89.132]) by mx1.state.vt.us (Post.Office MTA v3.5.4 release 224 ID# 0-0U10L2S100V35) with SMTP id us for ; Fri, 19 Mar 2004 13:30:51 -0500 From: "Ruth Gramolini" To: Subject: RE: Timestamp - to be or not to be? Date: Fri, 19 Mar 2004 13:31:48 -0500 Message-ID: <001601c40de0$705fabd0$8459699f@vttaxnet.tax.state.vt.us> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook 8.5, Build 4.71.2173.0 In-Reply-To: <73BB49215339D743903095833FFE4B17DA4E07@apophxex4.apollogrp.edu> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 Importance: Normal X-archive-position: 1281 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: rgramolini@tax.state.vt.us Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l 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@freelists.org [mailto:oracle-l-bounce@freelists.org]On Behalf Of Mark Moynahan Sent: Thursday, March 18, 2004 3:37 PM To: oracle-l@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@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@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 -----------------------------------------------------------------