my strftime func doesn't work. please help. - Mailing list pgsql-hackers

hello!

I tried to make a function, like strftime in C
called pstrtime( format, date )

here's the source... but when I compile it and create the function
under 6.3.2 first time it gives back an emty string.. after the backend
stops ;(

please correct my faults,
----------------------------------------------------------------------
#include <stdio.h>                              /* for sprintf() */
#include <string.h>
#include <limits.h>
#include "postgres.h"
#include "miscadmin.h"
#include "utils/builtins.h"
#include "utils/nabstime.h"
#include "utils/datetime.h"
#include "access/xact.h"

#define JDATE_2000      2451545

char       *pstrtime(char *format, DateADT val);


char *
pstrtime( char *format , DateADT val)
{
        int                     year,
                                month,
                                day;
        struct tm * time1;
        char *sometext;
        sometext = malloc(100);
        time1 = malloc(sizeof(struct tm));

        j2date(val + JDATE_2000, &year, &month, &day);

        time1->tm_year=year;
        time1->tm_mon=month-1;
        time1->tm_mday=day;

        strftime(sometext,90,format,time1 );
        free(time1);
        return( sometext );
}


anyway how to create this function under psql ?
C type               postgres type
-----------------------------------
DateADT            date
char *             ???????????

thanks,

    Best regards,
        Redax
.----------------------------------------------------------.
|Zsolt Varga            | tel/fax:   +36 36 422811         |
| AgriaComputer LTD     | email:     redax@agria.hu        |
| System Administrator  | URL:       http://www.agria.hu/  |
`----------------------------------------------------------'