Data that is recognizable as a date can be converted to datetime, smalldatetime time, and date. Incorrect month names lead to syntax errors. Dates that fall outside the acceptable range for the datatype lead to arithmetic overflow errors.
When datetime values are converted to smalldatetime, they are rounded up to the nearest minute.
Copyright © 2005. Sybase Inc. All rights reserved. |