Re: [HACKERS] timestamp/date in ecpg

2003-03-22 Thread Michael Meskes
On Fri, Mar 21, 2003 at 04:33:09PM +0100, Christoph Haller wrote: Hmm, maybe the transformation in the other direction is the culprit. What I do is call ts1 = PGTYPEStimestamp_atot(2000-7-12 17:34:29, NULL); followed by a text = PGTYPEStimestamp_ttoa (ts1); Needless to say the resulting

Re: [HACKERS] timestamp/date in ecpg

2003-03-21 Thread Christoph Haller
I started working on date/timestamp in ecpg. So far I can read date types from the DB and I can insert date into the DB. However there seems to be a bug in converting timestamp to ascii or vice versa. If anyone of you knows more about timestamp2tm etc. could you please have a look at

Re: [HACKERS] timestamp/date in ecpg

2003-03-21 Thread Christoph Haller
Hmm, maybe the transformation in the other direction is the culprit. What I do is call ts1 = PGTYPEStimestamp_atot(2000-7-12 17:34:29, NULL); followed by a text = PGTYPEStimestamp_ttoa (ts1); Needless to say the resulting text is not 2000-7-12 17:34:29. :-( I could not dig too deep into the

[HACKERS] timestamp/date in ecpg

2003-03-20 Thread Michael Meskes
I started working on date/timestamp in ecpg. So far I can read date types from the DB and I can insert date into the DB. However there seems to be a bug in converting timestamp to ascii or vice versa. If anyone of you knows more about timestamp2tm etc. could you please have a look at function