Oracle provide a lot of mechanisms to handle the time and date types.Formatting the date and time objects can be done in different ways.Please read the following articles to know more about timestamp in milliseconds and Date format.
Date and Timestamp format
Oracle PL/SQL: To_Timestamp Function | Datetime Format…
Comparing Oracle DATE and TIMESTAMP
Oracle DATE vs TIMESTAMP |Comparing Oracle DATE an…
Oracle DATE formating
Using oracle date format |Using the DATE Format Ma…
Also Read,
- Oracle to_char function and usage
- Using oracle date format |Using the DATE Format Mask in pl/sql
- Oracle comparing dates : dates, oracle, date comparison in oracle pl/sql
- ORA-01882: TIMEZONE REGION NOT FOUND |Oracle Error
- PL/SQL EXTRACT function for oracle datetime
- ALTER TABLE to ADD PRIMARY KEY in Oracle| Oracle ALTER TABLE
- oracle date difference | date difference in sql an…
- DATE Data type in Oracle|Oracle Dates and Times|Dates in Oracle
- Formatting date in SQL (Oracle) -Simple date forma…
- Database Schema | Oracle Schema Objects | What is database schema?
- Autonomous Transactions in PL/SQL
- SQL – Transaction Statements -Transaction Manageme…
Technorati Tags:
oracle date format, date format, sql date, to_date, to_char
Hello! Can you tell me how i can register mail at google google http://google.com