Re: How to check the date validity?

Path	csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!feeder.erje.net!eu.feeder.erje.net!xlned.com!feeder7.xlned.com!newsfeed.xs4all.nl!newsfeed4.news.xs4all.nl!xs4all!newsgate.cistron.nl!newsgate.news.xs4all.nl!post.news.xs4all.nl!not-for-mail
Return-Path	<rosuav@gmail.com>
X-Original-To	python-list@python.org
Delivered-To	python-list@mail.python.org
X-Spam-Status	OK 0.034
X-Spam-Evidence	'H': 0.94; 'S': 0.00; 'messages.': 0.05; 'postgresql.': 0.09; 'subject:How': 0.10; 'cc:addr:python-list': 0.11; 'db2,': 0.16; 'docs.': 0.16; 'from:addr:rosuav': 0.16; 'from:name:chris angelico': 0.16; 'garbage': 0.16; 'wrote:': 0.18; 'do.': 0.18; 'thu,': 0.19; 'cc:addr:python.org': 0.22; 'error': 0.23; 'mind.': 0.24; 'cc:2**0': 0.24; 'possibly': 0.26; 'header :In-Reply-To:1': 0.27; 'am,': 0.29; 'database,': 0.30; 'dec': 0.30; 'message-id:@mail.gmail.com': 0.30; '"the': 0.34; 'subject:the': 0.34; "i'd": 0.34; 'but': 0.35; 'received:google.com': 0.35; 'subject:?': 0.36; 'wrong': 0.37; 'that,': 0.38; 'up,': 0.60; 'more': 0.64; '26,': 0.68; 'grew': 0.84; 'subject:check': 0.84; 'forgotten': 0.91; 'to:none': 0.92; '2013': 0.98
DKIM-Signature	v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:date:message-id:subject:from:cc :content-type; bh=yr5uEnCS9y+oWrcP1BoWVfcp6T2dhKAZ4R6fxFMGtlg=; b=wiWm91UKz40Afv1nNykLSiEbZ4K/NZ1YwWuRwxMujUPqPNpAojpwTF5QUU9pHVFDut h592PtmWRbIWh5Eo0NC7YpPxJYqWACOBXUn2Dh8tP5DWczNllUfWHk7zQenHmV1QX7ZF 1sPSQl37mWdDIr9P7mUQ8O+XpRiGI5XDSKRxFygjykSdoLYMwmYtW5TC7KnYMPZQb2hE uaR5QrJtZGwz0Wo+604q0W9TANSyS36T8MRxudy6p2p+RrpEjXxm2GZ/x7DBLxoS2bwR 26O2982T+jAMDMAhzoDV7aL/D2VwquGhqjH/PVWEWdZjQB29fuMzxEAZtmJtpNWBQmji KIfQ==
MIME-Version	1.0
X-Received	by 10.66.216.129 with SMTP id oq1mr40160100pac.75.1388009011477; Wed, 25 Dec 2013 14:03:31 -0800 (PST)
In-Reply-To	<l9fa5f$fu0$1@ger.gmane.org>
References	<CA+FnnTxf1te0s4fmaXfP1wcCQ8esxrfyx3TN-JKizrMTyL-Lsg@mail.gmail.com> <CAPTjJmq_2d5LXKcEEc_85-Wjfh1=q0+uBS7=0YHkQ5dH6ubM=Q@mail.gmail.com> <l9fa5f$fu0$1@ger.gmane.org>
Date	Thu, 26 Dec 2013 09:03:31 +1100
Subject	Re: How to check the date validity?
From	Chris Angelico <rosuav@gmail.com>
Cc	"python-list@python.org" <python-list@python.org>
Content-Type	text/plain; charset=UTF-8
X-BeenThere	python-list@python.org
X-Mailman-Version	2.1.15
Precedence	list
List-Id	General discussion list for the Python programming language <python-list.python.org>
List-Unsubscribe	<https://mail.python.org/mailman/options/python-list>, <mailto:python-list-request@python.org?subject=unsubscribe>
List-Archive	<http://mail.python.org/pipermail/python-list/>
List-Post	<mailto:python-list@python.org>
List-Help	<mailto:python-list-request@python.org?subject=help>
List-Subscribe	<https://mail.python.org/mailman/listinfo/python-list>, <mailto:python-list-request@python.org?subject=subscribe>
Newsgroups	comp.lang.python
Message-ID	<mailman.4616.1388009020.18130.python-list@python.org> (permalink)
Lines	11
NNTP-Posting-Host	2001:888:2000:d::a6
X-Trace	1388009020 news.xs4all.nl 2873 [2001:888:2000:d::a6]:48688
X-Complaints-To	abuse@xs4all.nl
Xref	csiph.com comp.lang.python:62714

Show key headers only | View raw

On Thu, Dec 26, 2013 at 6:03 AM, Sibylle Koczian <nulla.epistola@web.de> wrote:
> MySQL used to accept wrong date and datetime formats without error messages.
> Garbage in the database, because validation was (is?) considered the job of
> "the application". Possibly that has changed, but I'd look into the docs. It
> isn't PostgreSQL.

Nor is it DB2, which is where I grew up, databases-wise. Yes, check
what MySQL will do. I'd forgotten that, or more likely suppressed it
from my mind.

ChrisA

Back to comp.lang.python | Previous | Next | Find similar | Unroll thread

Thread

Re: How to check the date validity? Chris Angelico <rosuav@gmail.com> - 2013-12-26 09:03 +1100

csiph-web