Hello everyone,
I cannot figure this out. I have a table like the following:
Tab_A
datetime_field datetime not null,
num_field bigint not null
I do a SELECT as follows:
Select datetime_field, num_field from Tab_A
where datetime_field='2005-03-10' and
num_field = 1234;
I return 2 rows correctly.
I then create the view:
Create view Tab_A_View as
select * from Tab_A;
I do a SELECT as follows:
Select datetime_field, num_field from Tab_A
where datetime_field='2005-03-10' and
num_field = 1234;
0 rows returned!
HOWEVER, IF I do the query as such:
Select datetime_field, num_field from Tab_A
where datetime_field='2005-03-10 00:00:00' and
num_field = 1234;
2 rows returned correctly. Is there an implementation difference?
Regards,
George
__________________________________________________________________
Switch to Netscape Internet Service.
As low as $9.95 a month -- Sign up today at http://isp.netscape.com/register
Netscape. Just the Net You Need.
New! Netscape Toolbar for Internet Explorer
Search from anywhere on the Web and block those annoying pop-ups.
Download now at http://channels.netscape.com/ns/search/install.jsp
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
