On 5 May 2016, at 11:25am, Cecil Westerhof <cldwesterhof at gmail.com> wrote:

> At
> the moment valid times can be marked as invalid and invalid times as valid.
> Probably imposable to completely circumvent, but it can be done a lot
> better.

I don't know what TimeZone you're in (your surname looks German) but at this 
level of detail it becomes important whether you're in the US or EU or any 
other place.  The phrase 'valid times' covers a large number of subjects and we 
can't tell which of them are important to you.

For instance, do you care if someone enters a time which is skipped by the 
clocks going forward ?  If at 1am your clocks skip straight to 2am, do you care 
if someone enters a time of 1:30am on that day ?

Or maybe you're in Samoa, which skipped the 30th of December 2011 entirely, and 
may one day want to go the other way, which it would do by having a 32nd of 
December or an unwarranted 29th of February.

You can get endlessly fussy about leap years and leap seconds and such things 
to the point where you know the Time Lords by name.  SQLite definitely cannot 
handle that level of detail and it should not be used for timestamp validation. 
 It's best either to find an external library for your programming language or 
tell yourself to relax and stop sweating the small stuff.

Simon.

Reply via email to