Received: from mailgw.rational.com (mailgw.rational.com [130.213.254.1]) by hub.org (8.9.3/8.9.3) with ESMTP id KAA84282 for ; Tue, 14 Dec 1999 10:41:15 -0500 (EST) (envelope-from hkirschn@Rational.Com) Received: from mailhub.rational.com (mailhub [130.213.131.8]) by mailgw.rational.com (8.9.3/8.9.3/RATIONAL-mailgw) with ESMTP id HAA02814; Tue, 14 Dec 1999 07:41:08 -0800 (PST) Received: from mail-de.europe.rational.com (mail-de.europe.rational.com [206.243.105.10]) by mailhub.rational.com (8.9.3/8.9.3/RATIONAL-mailhub) with ESMTP id HAA28330; Tue, 14 Dec 1999 07:41:02 -0800 Received: from mw-hkirschn (mw-hkirschn [206.243.105.22]) by mail-de.europe.rational.com (8.9.1/8.9.1/europe-1.12) with SMTP id QAA03136; Tue, 14 Dec 1999 16:40:57 +0100 (MET) Reply-To: From: "Harald Kirschner" To: Cc: "WeKIS" Subject: wildcards with datetime columns Date: Tue, 14 Dec 1999 16:40:42 +0100 Message-ID: <000501bf4649$94925c40$1669f3ce@mw-hkirschn.europe.rational.com> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook 8.5, Build 4.71.2173.0 Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3 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