Posted by --CELKO-- on 08/14/07 21:57

>> No. You need to change it to:

CREATE VIEW CurrentUserLogs (user_id, login_date, ..)
AS
SELECT user_id, login_date, ..
FROM UserLogs
WHERE login_date = convert(char(8), CURRENT_TIMESTAMP, 112)

(Or some other way to strip the time portion from CURRENT_TIMESTAMP)<<

Look at the DDL; I did that in the base table of the VIEW. I think it
is a better idea to protect data integrity in the base tables than in
apps or VIEWs.

[Back to original message]