Skip to Content.
Sympa Menu

freetds - RE: [freetds] Comment on change

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Frediano Ziglio <freddyz77 AT tin.it>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: RE: [freetds] Comment on change
  • Date: 05 Mar 2003 20:39:40 +0100

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





Archive powered by MHonArc 2.6.24.

Top of Page