I use ASP and Ms SQL 7. When I UPDATE a date/time field from an input say,22:00 the field is updated with 1/1/1900 22:00:00. How would I be able to drop that 1/1/1900 and just have 22:00 in that field. I do not want to store the date but just the time. This does not arise when I first created that record with time stamp in that field i.e using INSERT. Any assistance is very much appreciated. <BR>Thank you.<BR><BR><BR><BR>