Selecting based on date range

[Ruslan Zasukhin]

On 6/12/10 5:48 PM, "Jason Moehlman" <jmoehlma at moehlman.com> wrote:

Hi Jason,
 
> I am having an issue selecting a range of records using dates similar to:
> 
> select * from treportdata where ( tsdatetime>='2010-06-01' ) and (
> tsdatetime<='2010-06-30' ) order by tsdatetime
> 
> VStudio immediately crashes, on Mac OS X.

V4.6 ? else

This should be reported to mantis, with crash log at least.

If possible - small db also which reproduce this,

> In RB the  query returns no
> results.  Removing the date references and just selecting records like:
> 
> select * from treportdata order by tsdatetime
> 
> Works just fine.  I am not sure if I am specifying the where clause wrong for
> Valentina, this syntax works on several other DB types.
> 
> Any help would be appreciated.

Syntax looks correct for me ...

What about this yet

select * from treportdata
where ( tsdatetime>='2010-06-01' )
order by tsdatetime


select * from treportdata
where  tsdatetime>='2010-06-01'
order by tsdatetime


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]