Re: Finding bogus dates

From: Scott Ribe <scott_ribe(at)killerbytes(dot)com>
To: "John D(dot) Burger" <john(at)mitre(dot)org>, "pgsql-general postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Finding bogus dates
Date: 2007-01-18 23:22:39
Message-ID: C1D54F4F.60563%scott_ribe@killerbytes.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> But this won't work if one had a text column of dates in various
> formats, right?

Right. In my case I have bad data from a source I didn't control, exported
via code that I do control which happens to output YYYY-MM-DD. Well, except
that I don't do what I need to when MM or DD are more than 2 digits, but I'm
going back to look at that again ;-)

--
Scott Ribe
scott_ribe(at)killerbytes(dot)com
http://www.killerbytes.com/
(303) 722-0567 voice

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ron Johnson 2007-01-18 23:42:54 PG not rejecting bad dates (was Re: Finding bogus dates)
Previous Message Harpreet Dhaliwal 2007-01-18 23:04:02 Re: Dynamic loading of Perl Code in Postgres functions