my strftime func doesn't work. please help.
От | Zsolt Varga |
---|---|
Тема | my strftime func doesn't work. please help. |
Дата | |
Msg-id | Pine.LNX.3.96.980613090136.2367D-100000@lupus.agria.hu обсуждение исходный текст |
Ответы |
Re: [HACKERS] my strftime func doesn't work. please help.
|
Список | 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/ | `----------------------------------------------------------'
В списке pgsql-hackers по дате отправления: