You can use CONVERT for that.

DECLARE @TestDatetime DATETIME = GETDATE();

DECLARE @TestDate DATE;

DECLARE @TestTime TIME;

SELECT @TestDate = CONVERT(DATE,@TestDatetime);

SELECT @TestTime = CONVERT(TIME,@TestDatetime);

PRINT @TestDate;

PRINT @TestTime;

If you want the values inserted in seperate columns, you can let SQL Server do the heavy lifting:

CREATE TABLE #Test(TestDate DATE, TestTime TIME);

INSERT INTO #Test(TestDate,TestTime) VALUES (GETDATE(),GETDATE());

SELECT * FROM #Test;

edit: I noticed after posting this that your question was in a Reporting Services forum. If you use SQL Server as a source, you can do this with the TSQL I posted. If not, you can use the FORMAT function in SSRS.

Here's a nice article explaining all about it:

Formatting Dates [SSRS][/url]