SQL Sever Date Error

Results 1 to 3 of 3

Thread: SQL Sever Date Error

  1. #1
    Join Date
    Dec 1969

    Default SQL Sever Date Error

    Yes, I read the FAQ&#039;s first.<BR><BR>My column is defined as: <BR>dateReg Datetime Not Null Default Current_Timestamp<BR><BR>I&#039;m trying to put the following date string to this field:<BR>&#039;10/31/2004 4:34:33 PM&#039;<BR><BR>According to SQL Server Books On-line, this is a valid string. However, I keep getting this error:<BR>The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.<BR><BR>What am I doing wrong or is SQL Server screwed up? I&#039;m losing hair over this one...<BR><BR>Sparky<BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: SQL Sever Date Error

    I could be wrong, but I think in SQL Server the current timestamp is binary datatype...<BR><BR>Try changing the default value to be<BR>GetDate()<BR><BR>Should work out for you.<BR>

  3. #3
    Join Date
    Dec 1969

    Default 100% correct, Russell <eom>


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts