Date, DateTime, and Time Out Wrappers for SQL Views and Dynamic Views
Dynamic views containing Date, Time, or DateTime fields must be wrapped with the appropriate meta-SQL. PeopleTools uses the SQL directly from the view definition (view text) and doesn't generate anything, so no meta-SQL wrapping is done.
SQL views should not contain meta-SQL that wraps Date, Time, or DateTime fields.