FreeTDS Development Group

[Brian Bruns <camber AT ais.org>]

To get a CVS account just create a user on sourceforge and let me know 
what the username is, and i'll add you to the commiters list.

Typically, how I like to see things is, if you have small bug fixes and 
things of that nature, just check them in and make sure to note the change 
in the ChangeLog file.  For more substantial changes, post the patch here 
saying that you are planning on checking it in and give it a day or so, so 
the peanut gallery can make suggestions ;-)

For the BCP stuff, just check it in, as it worked only for a small number 
of cases before anyway.

Brian

On Fri, 7 Dec 2001, Bill Thompson wrote:

> Hi,
> 
> I have written some code to convert a string into a SYBDATETIME format.
> This will handle (nearly) all possible date/time formats as specified in
> the Sybase manuals / SQL server help. i.e  date formats as follows:
> 
> Apr[il] [15][,] 1996 
> Apr[il] 15[,] [19]96 
> Apr[il] 1996 [15]
> 
> [15] Apr[il][,] 1996 
> 15 Apr[il][,][19]96 
> 15 [19]96 apr[il]
> [15] 1996 apr[il]
> 
> 1996 APR[IL] [15]
> 1996 [15] APR[IL]
> 
> or...
> 
> [0]4/15/[19]96 -- (mdy)
> [0]4-15-[19]96 -- (mdy)
> [0]4.15.[19]96 -- (mdy)
> 
> but only mdy formats at the moment - I don't know how to capture if SET
> DATEFORMAT has been issued...
> 
> or...
> 
> [19]960415 
> 
> and time formats as follows :
> 
> 14:30
> 14:30[:20:999]
> 14:30[:20.9]
> 4am
> 4 PM
> [0]4[:30:20:500]AM
> 
> I have amended and tested this on my installation which is FreeTDS v5.2.
> This has involved adding about 500(!) lines of code to tds/convert.c 
> 
> I also have a stand alone "main" program with all the code in which I've
> used for testing.
> 
> I have no idea what to do with this now. Does someone want to QA the code
> ?
> Am I allowed to "check it in" ? etc. etc.
> 
> Best wishes,
> 
> Bill
> 
> ---
> You are currently subscribed to freetds as: [camber AT ais.org]
> To unsubscribe, forward this message to $subst('Email.Unsub')
>