How can I insert time in datetime without Date

[mooniron]

Would you please how to put time like hh:mm:ss into datetime column without date info. When I want to insert time into datetime column sql server automatically adds 1:1:1900 next to my time info. But I want only the time info to be inserted! Thanks and best wishes...

 

[sunila7]

Hi,

In a datetime filed u cannot store only timestamp..... but u can use SQL to only retrieve only the timestamp. try these SQLs

select convert(varchar(10),datefld,108) from tbl

select convert(varchar(12),datefld,114) from tbl

Sunil

 

[swampBoogie]

SQL server does not support a time datatype. The option you have is to use a varchar column.

 

[plantj]

Mooniron, Is the time you're working with a time-of-day or an elapsed-time? If it's time-of-day I would go with Sunil's suggestion - for elapsed then perhaps an integer value for minutes or seconds might be appropriate. swampBoogie's idea is best if you're not anticipating a need to do any type of calculations with it.