I must be missing the obvious
From: Joe Powell <joe.powell_at_lmco.com>
Date: 30 Jun 2004 09:03:42 -0700
Message-ID: <deea9325.0406300803.45a030f2_at_posting.google.com>
We datestamp each record in table X with sysdate. In order to query all table X records in the previous month including its last second, I search between the first day of the last and current month. But for reports, I show the end date of the report as the last second of last month because humans think "from 1 to 30" not "between 1 and 31". So what is the standard for these queries? I can to_char the datestamp--but that is very slow--and changing the datestamp's type to varchar2 is not possible nor am I sure desireable. Am I the only one with this question? Received on Wed Jun 30 2004 - 18:03:42 CEST
Date: 30 Jun 2004 09:03:42 -0700
Message-ID: <deea9325.0406300803.45a030f2_at_posting.google.com>
We datestamp each record in table X with sysdate. In order to query all table X records in the previous month including its last second, I search between the first day of the last and current month. But for reports, I show the end date of the report as the last second of last month because humans think "from 1 to 30" not "between 1 and 31". So what is the standard for these queries? I can to_char the datestamp--but that is very slow--and changing the datestamp's type to varchar2 is not possible nor am I sure desireable. Am I the only one with this question? Received on Wed Jun 30 2004 - 18:03:42 CEST