DateStyle
От | Mike Withers |
---|---|
Тема | DateStyle |
Дата | |
Msg-id | 3.0.32.20010810140700.01980100@sovereign.macarthur.uws.edu.au обсуждение исходный текст |
Ответы |
Re: DateStyle
|
Список | pgsql-general |
Can anyone tell if it is possible (and if yes how) to use a datestyle like: II-AAA-IIII where the "I" is an integer character and the "A" is an alpha character. An example would be the 12th of Febuary 1949 would be displayed as 12-Feb-1949. I cannot find anything in the last last 18 months in the archives and Bruce Momjian's book refers only to styles other than the one I have asked about. The reason I'm asking is that building a database to be compatible in format to an Oracle database. Also it seems to me that whatever digit only ordering one uses that it can be confusing to an outsider querying a database unless they know the format whereas the format I'm looking for is unambiguous. A possible solution I thought of would be store the date as characters but I'm not sure if I could date manipulation (like days between dates) using characters as the data. Any help would be appreciated. Mike Withers University of Western Sydney Australia
В списке pgsql-general по дате отправления: