![]() ![]() Getting Just The Date Or From DateTime Field.With Openrowset, How To Avoid A Field Being Treated As Datetime Type?.About The Type Field : Datetime And Smalldatetime.Converting Date Field From Informix To SQL Nvarchar.How To Add Date Field And Time Field (not Datetime Field ).Error Of Date Type Field In SQL Server 2000 & Mshflexgrid.How To Convert Datetime Field To A Date Field So Excel Recognize It As Data Type.What options do I have that will work? View 1 Replies no timestamp partĬreated a view of the Informix table where I cast the date fields as datetime year to fraction(5), which failed.Īltered the view to convert the date fields to char(10) with the hopes that SQL Server would implicitly cast them Using an OLE DB Source and a SQL Server Destination, I get DT_DBDATE to DT_DBTIMESTAMPĮrrors on two fields from Informix which are date data. I am trying to drag data from Informix to Sql Server. Informix Date Type Field To SQL Server Datetime Field Error Oct 17, 2007 ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |