Sql Server

[Moishe]

Hi All
Does anyone know how to create a table with times on one side having 2 columns per time like this:

---------------------------------------
6:00
---------------------------------------

----------------------------------------
6:30
----------------------------------------

-----------------------------------------
and so on

create table time
(
time datetime ??????
date datetime ??????
)
insert into time values(????????????????????)


Thanks for your reply

 

[wyrd]

Use DateTime column, then just insert the times;

INSERT INTO table VALUES(06:30:00)

I havent played to much with times, but Im pretty sure you need to store them in 24 hour format. Hope that helps.

 

[Moishe]

Thanks for your reply