FreeTDS Development Group

["Bill Thompson" <thompbil AT exchange.uk.ml.com>]

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