Обсуждение: wildcards with datetime columns

Folks,

how do I use wildcards in 'where' clauses together with datetime columns?

example:
select * from table where datum > 'Fri Dec 14%';

I use '%' as wildcard, but it does not work. What is the correct character
for that?

I get an error messages 'wrong datetime format' something like that. Any
hints?

Regards,  Harald

Rational Software GmbH        Telefon 089-62838237
Keltenring 15            Fax    089-62838537
D-82041 Oberhaching        Mobil   0170-4532237