How can we help you today? How can we help you today?

Smalldatetime force 30 minute slots

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
Sanjshah
0

Comments

1 comment

Sort by
  • 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.
    sam.blackburn
    0

Add comment

Please sign in to leave a comment.