|
|
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.
Navigation:
[Reply to this message]
|