[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 !
_________________________________________________________________
Dont 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