Posted by trevorjhughes on 06/09/06 00:23

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

[Back to original message]