Store Time Only In A Datetime Datafield In MS SQL

Hi,





I want to store time into a datetime datafield in MS SQL Database, but eventually, it was include a date prefix the time ! I had try the approach on following and get the invalid result.





Approach 1:


Dim strTime as String = "11:59:59 AM"


Output:


01-01-1900 11:59:59 AM





Approach 2:


Dim dtTime as DateTime = "11:59:59 AM"


Output:


1/1/0001 11:59:59 AM <- (error occur: unable add to DB cause date is not between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM)





* The time on the above is accompany with AM/PM.





Approach 3:


Dim strTime as String = "11:59:59 AM"


Dim strStartTime2 = DateTime.ParseExact(strStartTime, "hh:mm:ss", System.Globalization.CultureInfo.CurrentCulture)


Output:


01-01-1900 11:59:59 AM





Approach 4:


Dim strTime as DateTime = "11:59:59 AM"


Dim strStartTime2 = DateTime.ParseExact(strStartTime, "hh:mm:ss", System.Globalization.CultureInfo.CurrentCulture)


Output:


String was not recognized as a valid DateTime.





I know what cause the approach 4 get an error. That is because the strTime is declare as DateTime and that contain "AM/PM" in time.





My Question:


1]Can I just insert the time only to the DB without date?


2]If possible, what should I delcare in the variable(String/DateTime/..?)


3]How can I deal with the "AM/PM"? It must concate with time to identify daytime/night





If you know and have the solution, pls do me a favor and will be more appreciated.


Thank you





Calvin