Date Comparisons in SQL

Results 1 to 2 of 2

Thread: Date Comparisons in SQL

  1. #1
    Join Date
    Dec 1969

    Default Date Comparisons in SQL

    Need help here!!<BR><BR>I have to find a date within a colum called call_logged and this is what the field looks like<BR> 27/12/2000 17:59:48<BR>and I am just trying to select dates between a certain range. this is my sql statemnt<BR><BR>sql= "select * from allRawData " &_<BR> "where call_logged between fromdate and todate "<BR>set objRS = conn.execute (strDate)<BR><BR>It does work :( do I need to do anything with the formatting. the format of the dates is DD/MM/YYYY<BR><BR>Please help

  2. #2
    Join Date
    Dec 1969

    Default RE: Date Comparisons in SQL

    In SQL Server use the DateDiff() function - look it up in books online.<BR><BR>j<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