|
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
Navigation:
[Reply to this message]
|