Re: Date/Time Problem with V5.0.6 views

2005-07-28 Thread Gleb Paharenko
Hello. You said that you had created a view, but you continued using Tab_A instead of Tab_A_View in your next queries. Did you want to use view Tab_A_View? On my MySQL 5.0.9 all queries works both with view and original table. See: mysql> desc Tab_A; +++-

Date/Time Problem with V5.0.6 views

2005-07-22 Thread TheRefUmp
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 ro