How can I update field that is time to get rid of 1/1/1900?

[ghost2]

I have some time fields that I have to run a quick update to just get rid of the 1/1/1900 before the time to just the time? Any ideas all. Thanks

 

[donutman]

SELECT CONVERT(varchar, GETDATE(), 8)
As an example, that return just the time. Will that do?
-Karl

 

[ghost2]

That still attaches the date to it.

 

[Connatic]

This will do it, although it gives you Milliseconds aswell !

Example

SELECT CONVERT(varchar(10),GETDATE(),114)

 

[donutman]

I don't think that is what he wants either. I think what ghost2 wants is a time data type not a datetime. There isn't one. You could create a view that always made the table "look like" it only had the time. Just tell the front-end that it's a varchar field.
-Karl

 

[SQLBill]

Try:

SELECT SUBSTRING((CONVERT(VARCHAR(19), GETDATE(), 121)),12,19)

Just remember this...you can't have JUST time in a DATETIME datatype. So you need to convert it to a VARCHAR (or CHAR).

-SQLBill

 

[barbola]

I just have a calculated field:

[DOCDATE]-#1/1/1900#

or something like that.

Thanks!
Barb E.