How do I write Constraint expressions for datetime data types?

  • Thread starter Mark_Christjansen
  • Start date
M

Mark_Christjansen

Do I write Check Constraint expressions for Tables in datetime datatypes.
 
M

Mark_Christjansen

I think I solved my own problem. The expression, and I came up with is this:
(datepart(minute,[Time]) = 15 or datepart(minute,[Time]) = 45).
Thank you very much for responding to my posting.

Mark_Christjansen.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Automatically Scheduled Task with Start on Constraint and Neg Slack 0
sqlite-odbc write conflict 2
How to paste this down? 3
Two lines in one in one line - How to do 2
How to constraint parallel tasks execution 0
Create table statement constraint syntax 3
Internal Data Integrity (Type 4) Details Needed 1
Temporarily disable relationships/constraints 1

Top