FreeTDS Development Group

[Frediano Ziglio <freddy77 AT gmail.com>]

2011/5/9 Raymond R Rankins <rrr03 AT health.state.ny.us>:
>
> I too would like to know if the latest versions support the DATE, TIME and
> DATETIME2 datatypes.
>
> I have a need to use freebcp to import and export data from SQL Server on a
> Solaris box.
> Exporting of DATE columns seems to work fine, but when importing into a
> DATE column, I'm getting the "Msg 20049, Level 4 Data conversion resulted
> in overflow" error.
>
> -Ray
>
>

Simply not supported, protocol 7.3 is not supported so you have to use
protocol 7.2 which convert to DATETIME.

Currently 0.91 (which is in RC state) and 0.92 (which is developing)
are very similar. I don't have any plan, I don't know if James have
any plan either. I have some set of patches but currently no plan.

Frediano

>
>
>
>
> From:   Sebastien FLAESCH <sf AT 4js.com>
> To:     freetds AT lists.ibiblio.org
> Date:   05/09/2011 09:26 AM
> Subject:        [freetds] What's new list in FreeTDS 0.91 and 0.92
> Sent by:        freetds-bounces AT lists.ibiblio.org
>
>
>
> Hello,
>
> I was looking for a "What's new" list for 0.91 and 0.92.
>
> I found the NEWS and README files in the sources but it looks like these
> are not up to date.
>
> Can someone point me to a list of new features or changes?
>
> I am interested by SQL Server 2008 support, especially regarding new data
> types (DATE, TIME, DATETIME2).
> Structures and constants for these new types are defined in sqlncli.h by
> Microsoft.
> I could not find any equivalent in FreeTDS/include files...
>
> What is the status of SQL Server 2008 support today with FreeTDS 0.92?
>
> Thank you,
> Seb
>
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
>
> IMPORTANT NOTICE: This e-mail and any attachments may contain confidential 
> or sensitive information which is, or may be, legally privileged or 
> otherwise protected by law from further disclosure. It is intended only for 
> the addressee. If you received this in error or from someone who was not 
> authorized to send it to you, please do not distribute, copy or use it or 
> any attachments. Please notify the sender immediately by reply e-mail and 
> delete this from your system. Thank you for your cooperation.
>
>
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
>
>