[RESOLVED]time(7) data type entry

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

Leave a Reply