Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Data Transform System

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-06-20 : 19:49:32
Jen writes "Updating sql employee table - daily from as400 data source to SQL2000 database - the hire date field was set up as yymmdd so anyone hired in 2000 transforms as (207 for Feb 7 2000 or 1112 for Nov. 12, 2000) Have tried Convert and transformation wizard date type really stumped. Thanks for any help."
   

- Advertisement -