From: | Tony Caduto <tony(dot)caduto(at)amsoftwaredesign(dot)com> |
---|---|
To: | |
Cc: | "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Question about Postgresql time fields(possible bug) |
Date: | 2006-01-11 03:52:20 |
Message-ID: | 43C480F4.4030908@amsoftwaredesign.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-patches |
> That's not really the point. The ISO 8601 standard allows midnight to be
> expressed as 00:00:00 or 24:00:00 to enable you to tell which midnight is
> being referred to (ie. The beginning or the end of the day).
>
> PostgreSQL allows you to make use of that part of the standard, and as admin
> tool authors I think we should honour what it allows, provided it's not
> blatantly non-standard. It's up to the user to decide whether or not they
> actually make use of the facility.
For most database applications there is no practical reason to be using
a time of 24:00:00(at least none I can think of) and Delphi does not
allow a timestamp to contain 24 in the hours position.
I have reported it to my database component vendor, maybe they will
address it, maybe not.
Doing a little research I found that some DBs support it (DB2 for
example) and others do not.
Since I am targeting mostly windows users with my product, I guess for
now I will just allow it to be flagged as invalid.
Later,
--
Tony Caduto
AM Software Design
Home of PG Lightning Admin for Postgresql
http://www.amsoftwaredesign.com
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Dunstan | 2006-01-11 04:14:46 | Re: TODO-item: Add sleep() function, remove from regress.c |
Previous Message | Marc G. Fournier | 2006-01-11 03:39:24 | Re: cvs update taking a long time |
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Dunstan | 2006-01-11 04:14:46 | Re: TODO-item: Add sleep() function, remove from regress.c |
Previous Message | Tom Lane | 2006-01-11 03:44:39 | Re: TODO-item: Add sleep() function, remove from regress.c |