Results 1 to 2 of 2

Thread: INSERTING THE WRONG default date.

  1. #1
    jake craw Guest

    Default INSERTING THE WRONG default date.

    I was wondering if anyone had this same problem. In sql online help, it states that the date is defaulted to Jan 1, 1900 if only a time is entered. However, whenever we insert a date without a time, it defaults to 12,30,1899. This causes a problem when we do time comparisions. <BR><BR>Ex. we have 12:00 am in the db. the database defaults it to<BR>12,30,1899 12:00 am. <BR><BR>say <BR>if dbrst("dttime") = 12:00 am then &#060;--is 12:00 am 1-1-1900 to db.<BR><BR>the statement above will return false because the db defaults the non db time to 12:00 am 1-1-1900.<BR><BR><BR>Please help...<BR><BR><BR>

  2. #2
    Join Date
    Dec 1969

    Default please help me...:)

    i&#039ve been constantly refreshing to see if you guys have answered but no luck..<BR><BR>could it be something w/ ado..have u ever encountered this?

Posting Permissions

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