variable date precision
| От | christoph.dellavalle@goetheanum.ch |
|---|---|
| Тема | variable date precision |
| Дата | |
| Msg-id | D1ECCF616FF6D611A3C3000102755F454D57E4@s2bdcmail.aag обсуждение исходный текст |
| Ответы |
Re: variable date precision
|
| Список | pgsql-novice |
hi there i've got a problem with a field set up as type date. now we discovered that we have to allow not only full dates (2003-10-16)but also dates where we have only a month or even a year. we see that it is not a very good practice to usethe first of the month because it is ambiguous. on the other side, date does not allow entries like "2003-10-00". this db already contains quite a few records, so i'm not really keen on changing the data-type. nevertheless, i'm interestedin the theoretically correct solution as much as in a practical one, since it is not the first time i've come acrossthis problem. any suggestions are very welcome... chris
В списке pgsql-novice по дате отправления: