Rounding during conversion to or from money types  Converting to or from unitext

Chapter 15: Using the Built-In Functions in Queries

Converting date and time information

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. Converting to or from unitext

View this book as PDF