wildcards with datetime columns

From: "Harald Kirschner" <hkirschn(at)Rational(dot)Com>
To: <pgsql-sql(at)postgresql(dot)org>
Cc: "WeKIS" <wekis(at)gmx(dot)de>
Subject: wildcards with datetime columns
Date: 1999-12-14 15:40:42
Message-ID: 000501bf4649$94925c40$1669f3ce@mw-hkirschn.europe.rational.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Browse pgsql-sql by date

  From Date Subject
Next Message neko 1999-12-14 18:16:12 Re: [SQL] Deleting large objects from database.
Previous Message Lendvary Gyorgy 1999-12-14 14:11:02 SQLDA or UPDATE WHERE CURRENT OF