Date in SQL statement

Results 1 to 2 of 2

Thread: Date in SQL statement

  1. #1
    Join Date
    Dec 1969

    Default Date in SQL statement

    OK<BR>First the Field PostDt is a date field in a access database<BR><BR>My SQL statement is something like this:<BR>Select * from TableName Where PostDt = 1/1/02<BR><BR>I know there are records in there but still none are selected.<BR>I know it is some minor syntax error but I can&#039;t figure it out<BR><BR>Thanks

  2. #2
    Join Date
    Dec 1969
    Los Angeles, CA

    Default Maybe buy a good book

    or even read the FAQs<BR><BR>Select * from TableName Where PostDt = #1/1/02#<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