>Can I retreive the Date and Time portions of a DateTime into seperarte columns?
Look at Sergey's Message
and try
SELECT CONVERT(char(10),date_time_column, 101), CONVERT(char(8), date_time_column, 108) from your_db_table
Look in BOL for
convert what is 101 and 108
_______________________________________________________________
Testing displays the presence, not the absence of bugs.
If a software application has to be designed, it has to be designed correctly!
_______________________________________________________________
Vladimir Zografski
Systems Analyst