Posted by ZeldorBlat on 06/09/06 05:31

trevorjhughes@gmail.com wrote:
> I am using an MS Access front end to input data into a SQL server
> database. From Access I am generating an update query utilising an
> inline function. My problem is that when I update a time value,
> instead of updating the field with something like 08:00:00 it updates
> it to 1/1/1900 08:00:00. Is there a way to force the update to only
> use the hours minutes and seconds and ignore the date part?
>
> Any help would be greatly appreciated.
>
> Regards
> Trevor

There is no SQL Server datatype that stores only the time without the
date, so the answer is no. The solution is to ignore the date portion
when you use the value -- not when you insert/update it.

[Back to original message]