OK thanks for the answer.
I made my function with plpgsql to do formating,
It's not perfect but at least make it easy to do simple formating
==
CREATE FUNCTION myformat(text,text) returns text as'
DECLARE
i integer;
n integer;
strtemp text;
BEGIN
At 04:33 PM 2/14/03, [EMAIL PROTECTED] wrote:
When I run select to_date('20030212','MMDD') the output is 2/12/03
if I run select to_date( to_char(20030212,),'MMDD'); the
output is 6/23/05
How can I convert from integer into date format correctly?
Same as the first one, except l
George wrote:
OK this really is becoming one of the most frustrating experiences with
windows I have had. I have followed the instructions from differenet
sites and user groups and still no luck. I am stuck at getting the
ipc-daemon & service going. I have not found it on my machine. I am
usi
Yudie,
> Is there any default function for formating string in postgre sql?
> for instance:
> Format('123ABCDE', '-###-###') => '12-3AB-CDE'
>
> The closest function I know is the to_char() function but it only works for
numbers
No, there isn't. You could write one, though. For example, y
