working with dates

From: Dion (anonymous_at_discussions.microsoft.com)
Date: 07/26/04

  • Next message: Steve Kass: "Re: working with dates" 
    Date: Mon, 26 Jul 2004 12:43:28 -0700

    I am trying to join two tables on a date field. My
    problem is the hour/minute section. I want to match
    07/26/04 on both tables, regardless of the
    hour/minute/second piece of the number. I am used to
    doing this in Access/Excel by getting rid of the decimal
    part of the number, but can't find how to do this in SQL.
    And, I'm embarassed to admit, I wasn't sucessful in
    finding any articles to help.

    Thanks
    Dion

  • Next message: Steve Kass: "Re: working with dates"

    Relevant Pages

    • Re: Homeopathic Research
      ... regardless of the quality of the research or the methods ... that mistake made her famous she is reluctant to admit t. ... It proved Ennis made an error, ... Do you assert that Ennis is a superhuman, ...
      (misc.health.alternative)
    • Re: Man Charged for Having Sex With Teen Wife
      ... > I'll admit it is ridiculous to bring charges against a man for having sexual ... > relations with his own wife, regardless of her age. ...
      (misc.news.internet.discuss)
    • Non political, political post
      ... Regardless of your political persuasion, you have to admit that the ... Democratic candidate selection process is boring and bland compared to the ...
      (rec.boats)
    • Re: The greatest men ever
      ... regardless of how good a deal it was. ... Greg told me he had it laundered before he sold it to me. ... Larry's just ashamed to admit he goes up to Makeout Point ... .....McDonalds filet a fish sammich. ...
      (rec.humor)
    • Re: O_TEXT in microsoft environment
      ... Didn't you read the articles I posted? ... translation mode is the same regardless of a function used to open a file. ... Alex ...
      (microsoft.public.vc.language)