Skip to Content.
Sympa Menu

freetds - RE: [freetds] Date string differences between FreeTDS and Sybase ASE

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "James McGowan" <jmcgowan AT luxurylink.com>
  • To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
  • Subject: RE: [freetds] Date string differences between FreeTDS and Sybase ASE
  • Date: Fri, 19 Dec 2003 12:48:38 -0800

> From: Castellano, Nicholas [mailto:Nicholas_Castellano AT acml.com]
> Sent: Friday, December 19, 2003 8:42 AM
> To: 'FreeTDS Development Group'
> Subject: RE: [freetds] Date string differences between FreeTDS and
> Sybase ASE
>
>
>
> > From: James McGowan [mailto:jmcgowan AT luxurylink.com]
> > Sent: Thursday, December 18, 2003 7:32 PM
> > To: FreeTDS Development Group
> > Subject: RE: [freetds] Date string differences between
> > FreeTDS and Sybase ASE
> >
> >
> > Well, I did as you suggested and tried different
> > configurations of the [default] and [en_us] sections. No luck
> > thus far.
> >
> > The docs state that there's no way to display millisecond
> > values with FreeTDS. We don't care about milliseconds, yet
> > Sybase displays them and thus they are considered in the
> > function that parses the datetime string. I tried padding the
> > default FreeTDS setting with a zero as follows:
> >
> > [default]
> > date format = %b %d %Y %I:%M:%S0%p
> >
> > No luck. BTW, using %z in the format results in a
> segmentation fault.
>
> You need to be a little bit more precise about "no luck".
> What, exactly,
> happened after you made the change?
>
> You may have missed a "." between the seconds and the %p. Also, the
> milliseconds are usually expressed to three significant
> digits, so ".000"
> might be better depending on your application.
>
> What version of FreeTDS are you running? I remember fixing
> some segfault
> problems with %z, but I'm fairly certain that was before the
> last release.

After making the change, PHP returned a seg fault. Then, following your
advice, I tried:

[default]
date format = %b %d %Y %I:%M:%S.%z%p

and got another seg fault.

I'm running the nightly snapshot from 2003-12-18. Thanks for your help.




Archive powered by MHonArc 2.6.24.

Top of Page