>>How do you create time and date only portion of the dates? (SQL Server 2005)
>>
>>Thanks in advance.
>
>Not sure what you are asking... For cases where I only want to store and track the time and not a date, I use a datetime in sqlserver (has to be compatible with SQL 2000) field and store every date as 01/01/1901 so I can query and sort on the time.

How can you store only time portion of the datetime in the character field?