FreeTDS Development Group

[Frediano Ziglio <freddyz77 AT tin.it>]

Il mer, 2003-03-05 alle 18:18, Thompson, Bill D (London) ha scritto:
> Aahh, 
> 
> Thanks for this freddy. Let me follow up on this, but I bet its to do with
> this:
> 
> in sybase isql :
> 
> 1> select convert(char(30), convert(datetime,''))
> 2>
> 
>  ------------------------------
>  Jan  1 1900 12:00AM
> 
> (1 row affected)
> 
> I reckon thats what this is about. we've passed an empty string to dbconvert
> to convert to a date.
> I bet sybase dbconvert converts it to 'Jan 1 1900' , but luckily so do we
> now!
> 
> I didn't realise you were the author of the amazing math.
> 
> che forza il tuo programma!
> con ammirazione,
> 
> Bill
> 

I'm good in math but I copied formula from an internet page :) (well, I
modified a bit...)
Problem is default. time structure is initialized with a memset, I added
a line to set day = 1. Should solve problem.

grazie,
  freddy77