196Part II: SQL and SQL*PlusFunction Name TO_YMINTERVAL TRANSLATE UNISTR TABLE 10-1.Definition
lượt xem 4
download
196 Part II: SQL and SQL*Plus Function Name TO_YMINTERVAL TRANSLATE UNISTR TABLE 10-1. Definition Converts a character string of CHAR, VARCHAR2, NCHAR, or NVARCHAR2 datatype to an INTERVAL YEAR TO MONTH type. TRANSLATEs characters in a string into different characters. Converts a string into Unicode in the database Unicode character set. Transformation Functions (continued) The use of two of these functions, TO_CHAR and TO_DATE, has already been demonstrated in Chapter 9. TO_CHAR transforms a date into a character string (in the format you request). TO_CHAR can convert not just DATEs but also NUMBERs into character strings. TO_DATE is also a transformation function. It takes either...
Bình luận(0) Đăng nhập để gửi bình luận!
CÓ THỂ BẠN MUỐN DOWNLOAD