asked on
I have a table with an index value, date,time and a text field. There are constraints on the date and time fields. The constraints are:
DATE1 - ((datepart(hour,[DATE1]) = 0 and datepart(minute,[DATE1]) = 0 and datepart(second,[DATE1]) = 0 and datepart(millisecond,[DATE1]) = 0))
so the date must be like 20210812 00:00:00.000
TIME1 - ((datepart(day,[TIME1]) = 1 and datepart(month,[TIME1]) = 1 and datepart(year,[TIME1]) = 1900))
and the time must be like 19000101 08:23:50.010
What is the proper way to construct this insert statement? I will have values for index and text and can use GETDATE() but how do I format GETDATE()?
DATE1 - ((datepart(hour,[DATE1]) = 0 and datepart(minute,[DATE1]) = 0 and datepart(second,[DATE1]) = 0 and datepart(millisecond,[DATE1]) = 0))
so the date must be like 20210812 00:00:00.000
TIME1 - ((datepart(day,[TIME1]) = 1 and datepart(month,[TIME1]) = 1 and datepart(year,[TIME1]) = 1900))
and the time must be like 19000101 08:23:50.010
What is the proper way to construct this insert statement? I will have values for index and text and can use GETDATE() but how do I format GETDATE()?
The Value of Experts Exchange in My Daily IT Life
Experts Exchange (EE) has become my company's go-to resource to get answers. I've used EE to make decisions, solve problems and even save customers. OutagesIO has been a challenging project and... Keep reading >>
Mike
Owner of Outages.IO
Phoenix, Arizona, United States
Member Since 2016
Join a full scale community that combines the best parts of other tools into one platform.
Unlock 1 Answer and 4 Comments.
View membership options“All of life is about relationships, and EE has made a virtual community a real community. It lifts everyone's boat.”
William Peck
Member since 2004
Our community of experts have been thoroughly vetted for their expertise and industry experience.