where-statement for a date column

[Ruslan Zasukhin]

On 11/8/05 1:03 AM, "SoftIl" <softil at onlinehome.de> wrote:

Hi Paolo,

> Hi,
> how is the rigth syntax for a where-statement for an date column?
> 
> I tried this:
> 
> select * from myTable where dateCol like '\A04.10.2004'

It looks you do REGEX search, but use LIKE.

 
> but it dosen't work. I get no records return.
> 
> If I select the records without the where-statement I get all records return.
> In the column "dateCol" are this values for example:
> 
> 04.10.2004 00:00:00
> 15.05.2004 00:00:00

-- 
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]