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... [More]

  The DateTime datatype is build upon Float data type so you can easily convert any DateTime in a Float value and simultaneously a float value can also be converted into a DateTime. Using this functionality we can easily get the starting DateTime and Ending DateTime of a gi... [More]