can done as cast(col1, format date 'yyyy-mm-dd'
Attachments
Library
Quick Reference
Archives
Sample Index
2006 Indexes