Smalldatetime force 30 minute slots

Sanjshah

Hi,

I have a column that I am populating with a smalldattime, the start / end date is fine, however, I would like to force the Time part so that it only uses 1/2 periods rather than individual minutes.

Is this possible? any help in achieving this would be very welcome.

Thanks

sam.blackburn

You can achieve this sort of customization (and a lot more!) with a Python script, which can basically generate arbitrary values for SQL Data Generator to put in your database.