PRB: BCP Default of smalldatetime Uses Jun 8, 1932

ID: 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. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

Additional query words: sql6 time insert values

Keywords : kbprg SSrvBCP SSrvProg kbbug4.21 kbbug6.00
Version : 4.21 6.0
Platform : WINDOWS
Issue type :