On Friday 04 Oct 2002 11:37 am, Andreas Forsgren wrote:
> I'm stuck. The following two snippets gives me two different results,
> and I can't figure out why;
> = 5845507 and count(*) [1] gives me: 286109
> = 5986420 and count(*) [1] gives me: 286304
Nothing changed but different numbers of rows returned? Best look at the where
clause...
> where (b_nr
> like '12345678%' and datetime(ss7_rel_timestamp_sec) >=
> '2002-09-01' and datetime(ss7_rel_timestamp_sec) < '2002-10-01'
> and session_status_reached >= 20);
>
> where b_nr like '12345678%' and
> ss7_rel_timestamp_sec >= '2002-09-01' and ss7_rel_timestamp_sec
> < '2002-10-01' and session_status_reached >= 20;
Hmm - "datetime" - tell me sir, are you in a timezone other than Greenwich and
if you specify timezones explicitly does the problem go away?
--
Richard Huxton
