Data types Archive

• Oracle comparing dates : dates, oracle, date comparison in oracle pl/sql

  How to compare dates in oracle?There are a number of ways you can compare two dates in oracle to...

  Read More

• Oracle Dates and Times |SYSDATE|CURRENT_TIMESTAMP |SYSTIMESTAMP |DBTIMEZONE |LOCALTIMESTAMP

  The DATE type is stored in a special internal format that includes not just the month, day, and year,...

  Read More

• oracle to_date | Oracle/PLSQL: To_Date Function

  The purpose of TO_DATE in Oracle pl/sql is to convert char of CHAR, VARCHAR2, NCHAR, or NVARCHAR2 data type...

  Read More

• Oracle date difference | date difference in sql and PL/SQL

  Oracle maintains the SYSDATE pseudo-column to show the current system date and time. How to find the difference between two...

  Read More

• DATE Data type in Oracle|Oracle Dates and Times|Dates in OracleDATE Data type in Oracle|Oracle Dates and Times|Dates in Oracle

  In Oracle Date data is stored in fixed-length fields of seven bytes each, corresponding to century, year, month, day,...

  Read More

• Formatting date in SQL (Oracle) -Simple date formatting

  Formatting date in SQL (Oracle) -Simple date formatting.Here is few simple SQL date formatting examples that can be useful...

  Read More

• Oracle Data types

  Datatypes Every constant and variable has a data type ,which specifies the storage format. It also specifies the constraints...

  Read More