List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:September 16 2001 3:49am
Subject:Re: Date Comparison Issue
View as plain text  
At 8:22 PM -0700 9/15/01, Carl Schrader wrote:
>I have a table with a date field. I have a query that needs to output
>only if NOW()<ed3(date field) ed2 is datetime.

ed3?  ed2?

>The issue is this:
>select * from thesites where ED3>NOW()
>ED3='1999-12-31 00:00:00'
>the above query will output when ED3 is as above. NOW()='2001-09-15

Doesn't sound right.  Show us the output from the query, and the output
from "DESCRIBE thesites".

Paul DuBois, paul@stripped
Date Comparison IssueCarl Schrader16 Sep
  • Re: Date Comparison IssuePaul DuBois16 Sep