Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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



pgsql-sql by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group