Re: to_timestamp() and quarters
| От | Asher Hoskins |
|---|---|
| Тема | Re: to_timestamp() and quarters |
| Дата | |
| Msg-id | 4B8FB1C4.10509@piceur.co.uk обсуждение |
| Ответ на | Re: to_timestamp() and quarters ("A. Kretschmer" <andreas.kretschmer@schollglas.com>) |
| Список | pgsql-general |
A. Kretschmer wrote: > In response to Tom Lane : >> Asher Hoskins <asher@piceur.co.uk> writes: >>> I can't seem to get to_timestamp() or to_date() to work with quarters, >> The source code says >> >> * We ignore Q when converting to date because it is not >> * normative. >> * >> * We still parse the source string for an integer, but it >> * isn't stored anywhere in 'out'. >> > > Ouch, sound like MySQL / myisam: we accept things like foreign key, but > we don't implement that... > > +1 for raise an error or something, but no 'accept & ignore'. Thanks for the replies, nice to know I wasn't doing something silly! +1 for raising an error/warning from me too, it would have saved me some fruitless googling. Thanks, Asher.
В списке pgsql-general по дате отправления: