Converting strings to date and time data types.
If a string containing only a time value (no date) is converted to a date/time data type, SQL Anywhere uses the current date.
If the fraction portion of a time is less than 3 digits, SQL Anywhere interprets the value the same way regardless of the whether it is preceded by a period or a colon: one digit means tenths, two digits mean hundredths, and three digits mean thousandths.
SQL Anywhere converts the milliseconds value in the same manner regardless of the separator.
12:34:56.7 to 12:34:56.700 12:34:56:7 to 12:34:56.700 220.127.116.11 to 12:34:56.780 12.34.56:78 to 12:34:56.780 12:34:56.789 to 12:34:56.789 12:34:56:789 to 12:34:56.789
|Discuss this page in DocCommentXchange.
Send feedback about this page using email.
|Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1|