It's just the way EM shows datetime value with time portion of 12:00:00 AM. To verify that date and time is stored correctly, run query in QA
select mydatetimefield from mytable
>I am migrating about 4 gig of VFP data to SQL Server. I am using VFP COPY TO command, SQL Format Files, SQL BULK INSERT command being issued from VFP -> SQL via SQL Pass through.
>
>When I bring in datetimes with the time element of 12:00:00 AM...when I view the table in the Enterprise Manager I do not see a time element in the corresponding datetime field. When I change the time element in the VFP Table to 12:00:01 AM (1 second past midnight) and redo the export import process...the time element shows up in the Enterprise Manager as it should as 12:00:01 AM.
>
>Thanks Ron
--sb--