Date matching for better performance.

Article View: borland.public.interbase.sql

Article #462

Back to borland.public.interbase.sql Previous Next

#462

From: Monalee Bhandge
Date: Sun, 25 Nov 2007 08:07

11 lines
1147 bytes

Dear,
  I have one column trans_date of DATE type.How should I match trans_date column?
e.g If I want to match 01-April-2007 then
    by which data retrive fast.

    WHERE trans_date='2007-04-01';
     OR
    WHERE trans_date='04-01-07';
     OR
    WHERE trans_date='04-01-2007';

Technical Details

Message-ID: <47493b3e$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!proxad.net!feeder1-2.proxad.net!213.200.89.82.MISMATCH!tiscali!newsfeed1.ip.tiscali.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: 114a0e,1fb34ae6a20843ff,start
X-Google-Attributes: gid114a0e,public,usenet
X-Google-Language: ENGLISH,ASCII-7-bit
From: "Monalee Bhandge" <monaleeb@gmail.com>
Sender: "Monalee Bhandge" <monaleeb@gmail.com>
Reply-To: "Monalee Bhandge" <monaleeb@gmail.com>
Subject: Date matching for better performance.
Newsgroups: borland.public.interbase.sql
X-User-Info: 203.212.197.223     
NNTP-Posting-Host: 207.105.83.66
Message-ID: <47493b3e$1@newsgroups.borland.com>
Date: 25 Nov 2007 01:07:10 -0700
X-Trace: newsgroups.borland.com 1195981630 207.105.83.66 (25 Nov 2007 01:07:10 -0700)
Lines: 11
Path: arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!proxad.net!feeder1-2.proxad.net!213.200.89.82.MISMATCH!tiscali!newsfeed1.ip.tiscali.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail