[freetds] Date string differences between FreeTDS and Sybase ASE

Castellano, Nicholas Nicholas_Castellano at acml.com
Fri Dec 19 11:41:32 EST 2003


> 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.

-----------------------------------------
The information contained in this transmission may contain privileged and confidential information and is intended only for the use of the person(s) named above. If you are not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, any review, dissemination, distribution or duplication of this communication is strictly prohibited. If you are not the intended recipient, please contact the sender immediately by reply e-mail and destroy all copies of the original message. Please note that we do not accept account orders and/or instructions by e-mail, and therefore will not be responsible for carrying out such orders and/or instructions.




More information about the FreeTDS mailing list