> I could have a bit of a nightmare converting this app to
> MySQL - there are a whole lot of rather complicated calendar
> queries in it...
You might be ok
SELECT DateField, AnotherField
FROM SomeTable
Worked fine with no problems at all.
SELECT DateField, count(AnotherField)
FROM SomeTable
GROUP BY DateField
This was where it started going wrong and needed casting to a char type
instead of a date. So long as you don't group on the date field you should
be ok.
--
Jay
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
