[thelist] CF & MySQL: Date/Time operations

Ken Moore psm2713 at hotmail.com
Tue Jul 18 16:33:43 CDT 2006


Hi Minh Lee Goon

I'm still not certain what you are trying to do.

Assuming that CreateODBCDate is defined by you somewhere else, drop the #. 
Example:
SELECT MyDate
FROM ThisTable;

>
>I should probably give you a little more information.
>
>MySQL version is 4. This query is actually a query of another query.
>Would that make a difference in MySQL?
>
>
>
>Minh Lee Goon wrote:
> > I have this simple query that doesn't work in MySQL, but it does with
> > Access. Any ideas on how I can get it running again? Thanks.
> >
> > SELECT *
> > FROM   Interview
> > WHERE  Interview_Date < #CreateODBCDate(Now())#
> > ORDER BY Interview_Date DESC
> >
>
>
>--
>
>* * Please support the community that supports you.  * *
>http://evolt.org/help_support_evolt/
>
>For unsubscribe and other options, including the Tip Harvester
>and archives of thelist go to: http://lists.evolt.org
>Workers of the Web, evolt !

_________________________________________________________________
Don’t just search. Find. Check out the new MSN Search! 
http://search.msn.click-url.com/go/onm00200636ave/direct/01/




More information about the thelist mailing list