Quick Links

substring ..

From:	Jeff MacDonald <jeff(at)hub(dot)org>
To:	pgsql-sql(at)postgresql(dot)org
Subject:	substring ..
Date:	2000-12-19 19:06:47
Message-ID:	Pine.BSF.4.21.0012191505370.3386-100000@rage.hub.org
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-sql

hi folks..

i want to do this to a datetime field..

select foo from table where substr(datefoo,1,11) = '2000-12-14';

it returns no results yet..

select substr(datefoo,1,11) does return some values that say
2000-12-14

any clues ?

Jeff MacDonald,

-----------------------------------------------------
PostgreSQL Inc | Hub.Org Networking Services
jeff(at)pgsql(dot)com | jeff(at)hub(dot)org
www.pgsql.com | www.hub.org
1-902-542-0713 | 1-902-542-3657
-----------------------------------------------------
Facsimile : 1 902 542 5386
IRC Nick : bignose
PGP Public Key : http://bignose.hub.org/public.txt

Responses

Re: substring .. at 2000-12-19 20:06:14 from Josh Berkus
Re: substring .. at 2000-12-19 20:07:33 from Stephan Szabo
Re: substring .. at 2000-12-19 20:08:14 from Joel Burton
Re: substring .. at 2000-12-19 20:13:09 from Tulio Oliveira
RE: substring .. at 2000-12-19 20:14:00 from Francis Solomon
Re: substring .. at 2000-12-19 21:31:42 from Robert B. Easter
Re: substring .. at 2000-12-19 22:12:09 from Jie Liang
Re: substring .. at 2000-12-20 07:42:56 from Karel Zak

Browse pgsql-sql by date

	From	Date	Subject
Next Message	Josh Berkus	2000-12-19 20:06:14	Re: substring ..
Previous Message	Frank Joerdens	2000-12-19 18:43:57	Re: Tree structure table normalization problem (do I need a trigger?)