From oracle-l-bounce@freelists.org Mon Sep 12 05:43:05 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j8CAh4Xf011898 for ; Mon, 12 Sep 2005 05:43:04 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j8CAh0hJ011877 for ; Mon, 12 Sep 2005 05:43:00 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id A5CEC1EBA09; Mon, 12 Sep 2005 05:42:57 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 31459-03; Mon, 12 Sep 2005 05:42:57 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 268621EBA13; Mon, 12 Sep 2005 05:42:57 -0500 (EST) Subject: Date comparison Message-ID: From: manoj.gurnani@polaris.co.in Date: Mon, 12 Sep 2005 16:10:34 +0530 To: Oracle-L@freelists.org Cc: MIME-Version: 1.0 X-imss-version: 2.029 X-imss-result: Passed X-imss-approveListMatch: *@polaris.co.in X-MIMETrack: Serialize by Router on psldns.polaris.co.in/Polaris(Release 6.5.4FP1|June19, 2005) at 09/12/2005 04:10:58 PM, Itemize by SMTP Server on Trend-Smtp/Orion/IN(Release 6.5.1|January 21, 2004) at 09/12/2005 04:17:47 PM, Serialize by Router on Trend-Smtp/Orion/IN(Release 6.5.1|January 21, 2004) at 09/12/2005 04:17:51 PM, Serialize complete at 09/12/2005 04:17:51 PM Content-Type: text/plain; charset=US-ASCII X-archive-position: 25279 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: manoj.gurnani@polaris.co.in Precedence: normal Reply-To: manoj.gurnani@polaris.co.in X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=-4.7 required=5.0 tests=BAYES_00,NO_REAL_NAME autolearn=no version=2.63 Hi All, I've a date column in a oracle db table which stores date and time values. Is it advisable to use a date variable directly in a comparison with a date column without any formatting or using any other conversion functions like to_char. here the date variable also stores the date & time part from the table . e.g select * from where = Regards Manoj This e-Mail may contain proprietary and confidential information and is sent for the intended recipient(s) only. If by an addressing or transmission error this mail has been misdirected to you, you are requested to delete this mail immediately. You are also hereby notified that any use, any form of reproduction, dissemination, copying, disclosure, modification, distribution and/or publication of this e-mail message, contents or its attachment other than by its intended recipient/s is strictly prohibited. Visit Us at http://www.polaris.co.in -- http://www.freelists.org/webpage/oracle-l