Generate Random number inside SQL using timestamp (GetDate function) One of ...
Extract Date from Datetime field in SQL An old method I found in my archive.
50 chars max.