By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,419 Members | 1,609 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,419 IT Pros & Developers. It's quick & easy.

Times in SQL Server

P: n/a
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

Jun 9 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a

tr***********@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.

Jun 9 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.