I need to insert data from a form representing hh:mm:ss AM or PM into a sql server time(7) datatype but having problem formatting the AM/PM in order to insert it.
Regards
If I remember correctly, the time datatype in sql doesn’t accept am/pm. It uses a 24 hour time so you just need to eliminate the AM/PM and convert it to strictly a time by adding 12 when it’s PM.
So how would you handle 12:01 PM?
engcanada
So how would you handle 12:01 PM?
use 24 hour format.
engcanada
So how would you handle 12:01 PM?
Just insert 12:01:00