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 res

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

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