[teiid-dev] [teiid-users] sql server time column

[Larry O'Leary]

On Thu, 2009-07-23 at 10:09 -0400, Steven Hawkins wrote:
> Several changes in Teiid have made our old behavior of allowing users to mark datatime columns from SQL Server/Sybase as time type in Teiid not work (it used to only fail in some situations with prepared statements).  The issue is that SQL Server treats the default year for a time value as 1900 instead of 1970.  
> 
> My preferred approach is to have users represent the source datetime as a timestamp in Teiid (which is the default upon import), but perform type reconciliation in a virtual model using the following expression - convert(timestampadd(SQL_TSI_YEAR, 70, <source datatime>), time).

Can this not be done in the connector?
-- 
Larry O'Leary <loleary at redhat.com>
Red Hat, Inc.