Posted by Erland Sommarskog on 08/15/07 06:57

--CELKO-- (jcelko212@earthlink.net) writes:
>>> 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.

Yes, but CURRENT_TIMESTAMP still returns both hours and minutes. Your
view definition is not going to help you.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]