Storing dates as longs

2004-06-28 Thread yahootintin . 1247688
Hi, I'm storing my dates as longs. The longs are converted to strings and padded with zeros. Am I going to run into issues with this? Based on other mailing list postings, I suspect that this may cause the too many boolean queries issue when I search for date ranges. Is this true? What

Re: Storing dates as longs

2004-06-28 Thread Otis Gospodnetic
Hello, The standard answer to this question is: If you don't need your dates to be very precise, trim milliseconds. Trim more (e.g. seconds) if that information is not relevant. Otis --- [EMAIL PROTECTED] wrote: Hi, I'm storing my dates as longs. The longs are converted to strings

Re: Storing dates as longs

2004-06-28 Thread Erik Hatcher
On Jun 28, 2004, at 11:17 AM, Kevin Burton wrote: Otis Gospodnetic wrote: Hello, The standard answer to this question is: If you don't need your dates to be very precise, trim milliseconds. Trim more (e.g. seconds) if that information is not relevant. So the question is should use store this