TimeStamp in SQL

[Welthey]

I have a field in SQL that has a time in it. SQL has added the 1/1/1900 to
the field. I need to be able to strip that date out and show only the time
as I have another table in SQL where the date does not appear just the time.
Is there anyway to do this? I have tried the right function but when I do
that it take the HH:MM:SS and converts it to HH:MM. I need to have the
seconds as well.

Thanks

 

[Paolo]

Hi Welthey,

I think format(yourfield,"hh:mm:ss") should work.

HTH Paolo

 

[Klatuu]

Use the TimeValue function.