Is the date really stored as an integer? You say so, but then you're
trying a wildcard (i.e. char) search. If so, try this (pretending
date_int is your date stored as an integer column in the table
large_table):
From: jeff <[EMAIL PROTECTED]>
> I need to be able to search by partial dates.
> What is the best way to search?
You ~could~ do something harsh like:
SELECT *, substring(myDate, 1, 2) as month
FROM myFunnyTable
WHERE month = '06'
But unless you are only going to need this data
I inherited a large table (50 million records) with the date stored as an
integer in the format (mmddyyy). The dates go back to the 1800's and in the
1990's so the year is either 8xx or 9xx.
I need to be able to search by partial dates. For example, some searches
need to pull every record for the
