Re: 3 digit ISO dates

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Monday 15 September 2003 09:09, Christopher Kings-Lynne wrote:
> Hi,
>
> Are we going to address the fact that you can't enter 3 digit years without
> a leading 0?
>
> australia=# select '111-01-01'::date;
> ERROR: Bad date external representation '111-01-01'
>
> australia=# select '0111-01-01'::date;
> date
> ------------
> 0111-01-01
> (1 row)
>
> I can't see any reason why we shouldn't allow it???

Works here(7.4beta2):

andreak=# select '111-01-01'::date;
date
- ------------
0111-01-01
(1 row)

andreak=# select version();
version
- -----------------------------------------------------------------------------------------------------------
PostgreSQL 7.4beta2 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2.2
(Mandrake Linux 9.1 3.2.2-3mdk)
(1 row)

- --
Andreas Joseph Krogh <andreak(at)officenet(dot)no>
Managing Director, Senior Software Developer
OfficeNet AS

- - There are 10 kinds of people in the world, those that can do binary
arithmetic and those that can't.

gpg public_key: http://dev.officenet.no/~andreak/public_key.asc
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)

iD8DBQE/ZW3mUopImDh2gfQRAlNIAKCF62WbRGJSP1QwM+qJzUjBiSM3gQCbBM4N
SmXAdFqCK+Wf6EVTw/W9buo=
=+Hrc
-----END PGP SIGNATURE-----