Microsoft KB Archive/141164

{|
 * width="100%"|

PRB: BCP Default of smalldatetime Uses Jun 8, 1932

 * }

Q141164

-

The information in this article applies to:


 * Microsoft SQL Server versions 4.2x, 6.0

-

BUG# NT: 11758 (4.21)

SYMPTOMS
When using only a time value for BCP inserts, BCP defaults the date to Jun 8, 1932. Inserting the same value via the INSERT statement uses Jan 1, 1900.

  Example: insert into tblSmall values ("10:20") Produces: Jan 1 1900 10:20AM

BCP pubs..tblSmall in bcp.dat /Usa /P -c Produces: Jun 8 1932 10:20AM

WORKAROUND
Use fully defined date and time values.

STATUS
Microsoft has confirmed this to be a problem in Microsoft SQL Server version 4.21a.

Additional query words: sql6 time insert values

Keywords : kbprogramming

Issue type : kbbug

Technology : kbSQLServSearch kbAudDeveloper kbSQLServ600 kbSQLServ420OS2