Hi,
I'm trying to convert the following query into mySQL, this
currently
working with MS SQL although not with mySQL.
SET DATEFORMAT dmy declare  d datetime set d =
'01/12/2007' select *
from matrix.subscriptions where d between startdate and
enddate
The above query searches a date between two fields.
(startdate and
enddate)
Anyone got any idea how this can be done within mySQL
Thanks for your help
David
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the
Google Groups "PHP & MySQL" group.
To post to this group, send email to phpmysqlgooglegroups.com
To unsubscribe from this group, send email to
phpmysql-unsubscribegooglegroups.com
For more options, visit this group at ht
tp://groups-beta.google.com/group/phpmysql?hl=en
-~----------~----~----~----~------~----~------~--~---
|
