Date time format in oracle 11g
Format Models. A format model is a character literal that describes the format of datetime or numeric data stored in a character string. A format model does not change the internal representation of the value in the database. When you convert a character string into a date or number, a format model determines how Oracle Database interprets the string. Actually, there is not one, not two but four data types for datetime values in the Oracle database: DATE is the oldest and most widely used data type. Though the name is "DATE", it stores also information about the time. Internally, DATE stores year, month, day, hour, minute and second as explicit values. In Oracle, TO_DATE function converts a string value to DATE data type value using the specified format. In SQL Server, you can use CONVERT or TRY_CONVERT function with an appropriate datetime style. Oracle: - Specify a datetime string and its exact format SELECT TO_DATE('', 'YYYY-MM-DD') FROM dual;.