The next problem I need to resolve is accessing records in a PHP program
from a mssql database where the index I need to select on is a datetime
field and PHP appears to be ignoring the time portion.
The field is defined as
StartDate datetime 8
and would, when looking from Enterprise Manager, contain something
similar to
2006/03/10 06:00:00 AM.
The select statement I use is similar to:-
select ID, Name, StartDate, EndDate FROM db WHERE ID=@ID AND
@Today>=StartDate AND @Today <=EndDate ORDER BY EndDate
This, of course, means that two records where only the time is different
are both selected whereas all I need is to get the one within the
current date/time period.
Suggestions please.
--
Regards,
Alf Stockton www.stockton.co.za
Give your very best today. Heaven knows it's little enough.
My email disclaimer is available at www.stockton.co.za/disclaimer.html
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
