Re: Casting timestamp with time zone to varchar automatically
От | Pierre-Frédéric Caillaud |
---|---|
Тема | Re: Casting timestamp with time zone to varchar automatically |
Дата | |
Msg-id | opsb62put1cq72hf@musicbox обсуждение исходный текст |
Ответ на | Re: Casting timestamp with time zone to varchar automatically ("Jim C. Nasby" <decibel@decibel.org>) |
Список | pgsql-general |
Idea : Create a function with the same name as your function, but which takes a timestamp as an argument, converts it to a string according to your specifications, then calls your function which needs a string. Postgresql will decide which function to call according to the types of the arguments. > Unfortunatly, that still doesn't really answer my question. I have a > generic function that accepts varchars, and I'd like to be able to feed > it timestamps without explicitly converting. That's why I'd like to know > if there is a specific reason there's no default timestamp -> varchar > cast. > > On Tue, Aug 03, 2004 at 03:57:36PM +0900, Michael Glaesemann wrote: >> >> On Aug 3, 2004, at 3:12 PM, Jim C. Nasby wrote: >> >> >Is there any reason why there isn't a predefined cast to go from a >> >timestamp to a varchar? Is there a reason not to add one? >> >> to_char should do what you need. People often need a specific form of >> timestamp if they need it to be a text value (rather than a native >> timestamp data type). to_char provides lots of flexibility >> >> >> Michael Glaesemann >> grzm myrealbox com >> >
В списке pgsql-general по дате отправления: