DATETIME - Time only needed

[amanjsingh]

Hi,

I'd like to know how to delete Date part of the DATETIME in SQL Server. I currently have 12/30/1899 12:30:00 AM sort of values in the DB and would like have or use only the Time part.

Thanks
AJ

[ck9663]

Hi,

I'd like to know how to delete Date part of the DATETIME in SQL Server. I currently have 12/30/1899 12:30:00 AM sort of values in the DB and would like have or use only the Time part.

Thanks
AJ

Check this out.

-- CK

[TimHop12]

Here you go:

Select convert(varchar(10),getdate(),108)