TimeStamp in SQL

  • Thread starter Thread starter Welthey
  • Start date Start date
W

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
 
Back
Top