John W. Colby
jcolby at colbyconsulting.com
Tue Feb 25 13:07:25 CST 2003
I have discovered that in all the cases so far, my problems upsizing a table has been a date field. In one table, I actually split out the data and time into separate fields - and want to keep it that way. Unfortunately I think the time being in the date by itself makes the date look to SQL Server like it is back at the beginning of time (date wise). IOW, without a data, the time in that field looks like it's in the year 1000 or something, which is invalid in SQL Server. Which seems pretty weird all by itself - what happens if you want to log the age of an object found in a tomb or something? Anyway, is there a way to allow just the time portion to upsize to SQl Server? Or am I going to have to append the time to a valid date, then change the way I do business? John W. Colby Colby Consulting www.ColbyConsulting.com ---------------------------------------------------- Is email taking over your day? Manage your time with eMailBoss. Try it free! http://www.eMailBoss.com