stoing date (date only not time with date) and time seperately in SQL server

[marinajogy]

Hi
I am using SQL server 2000.
I want store date (date only not time with date) and time seperately
in a table, also want to searchers based on these fileds.

ex: select * from tablename where datefield>10/12/2008 and timefield>12:30 - assume time in 24 hour format

thnaks in advance

[Alsvha]

Mind if I ask why?

[davide++]

Hi all.

I don't know SQLServer, but I think there're some functions to manage the dates, so you can extract the date part and the time part from a date before inserting the rows. See the documentation.

But I agree with Alsvha, usually there are no good reasons to store date and time separately.