Pinned topic Is rand_lookup only valuable for CHAR / VARCHAR type?
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Is rand_lookup only support CHAR / VARCHAR type field?
Updated on 2013-01-10T15:06:09Z at 2013-01-10T15:06:09Z by SystemAdmin
Re: Is rand_lookup only valuable for CHAR / VARCHAR type?2013-01-09T13:22:14ZThis is the accepted answer. This is the accepted answer.Hi sbjerry,
RAND_LOOKUP will lookup from a source that you specify and return replacement values from a column (or columns) that you specify. So, if you are looking to replace a DATETIME column with something random from a lookup table, create the lookup table with a type of DATETIME.
For flexibility between source and target, refer to the Common Elements Manual Chapter 5 (Column Maps) and review the section titled "Compatibility Rules for Column Maps"
Hope that helps.