Here is what I just used today:
SELECT CAST(cast(current_timestamp AS VARCHAR(19)) AS TIMESTAMP(0)) ;
Ralph Daugherity Cingular Wireless
Recent Threads
Attachments
Library
Quick Reference
Useful Links
Rules of Conduct
FAQs
Join the Forum
Archives
Sample Index
2004 Indexes