Results 1 to 2 of 2

Thread: SQL DATE

  1. #1
    Nathan Masek Guest

    Default SQL DATE

    In a SQL statement do I need to surround Date fields with #s &#039;s or nothing or ....??<BR><BR>- Thanks<BR>- Nathan Masek

  2. #2
    Join Date
    Dec 1969

    Default from the faq's.

    "Note that Access is the only database that uses #...# for dates instead of simply &#039;...&#039;. "<BR><BR>at the bottom of this faq<BR>http://www.aspfaqs.com/aspfaqs/ShowFAQ.asp?FAQID=58<BR><BR>located in<BR>http://www.aspfaqs.com/aspfaqs/ShowCategory.asp?CatID=21<BR><BR>.<BR><BR>that one can be a little difficult to find....but I was <BR>just reading it the other day.<BR><BR>

Posting Permissions

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