In SQL, you can generate Random DateTime,Integer ,Numeric and String value with the use of Checksum function and NEWID() function. Run the following query and analysis the result-

SELECT GETDATE() - (CheckSUM(NEWID()) / 1000000) AS RandomDate,
		CheckSUM(NEWID()) / 100000 AS RandomINT,
		CONVERT(Numeric(18,2), (CheckSUM(NEWID()) / 10000.5)) AS RandomNumeric,
		LEFT(REPLACE(NEWID(),'-',''),10) AS RandomString