Please note: For immediate customer service enquiries, you should contact SSE on one of the published SSE contact numbers or by email. SSE do not always reply to messages on social media. Complaints should be processed by phone, email and in writing only.
TO_CHAR - Convert Datetime to String - Oracle to SQL Server Migration. In Oracle, TO_CHAR function converts a datetime value (DATE, TIMESTAMP data types i.e.) to a string using the specified format. In SQL Server, you can use CONVERT or CAST functions to convert a datetime value (DATETIME, DATETIME2 data types i.e.) to a string. Oracle:
In these cases, Oracle Database returns UNKNOWN (see the examples that follow for additional information). The field you are extracting must be a field of the datetime_value_expr or interval_value_expr. For example, you can extract only YEAR, MONTH, and DAY from a DATE value. Likewise, you can extract TIMEZONE_HOUR and TIMEZONE_MINUTE only from the TIMESTAMP WITH TIME ZONE datatype.