=> Invalid character value for cast specification

  • Thread starter Thread starter Rhonda Fischer
  • Start date Start date
R

Rhonda Fischer

Hello,

I am attempting to save a time of 10:30 in my
Access Project to an SQL table column of type
smalldatetime and the error I receive is:

Invalid character value for cast specification

Is there a way of dealing with time separate from
date?

Your thoughts would be greatly appreciated.

Thank you kindly
Rhonda
 
You might want to check the range of date values that can be stored in a
SmallDateTime field.
 
Back
Top