Home
Oracle PL / SQL
Aggregate Functions
Analytical Functions
Char Functions
Constraints
Conversion Functions
Cursor
Data Type
Date Timezone
Hierarchical Query
Index
Insert Delete Update
Large Objects
Numeric Math Functions
Object Oriented Database
PL SQL
Regular Expressions
Report Column Page
Result Set
Select Query
Sequence
SQL Plus
Stored Procedure Function
Subquery
System Packages
System Tables Views
Table
Table Joins
Trigger
User Previliege
View
XML
Menu
SYSDATE « Date Timezone « Oracle PL / SQL
Oracle PL / SQL
Date Timezone
SYSDATE
1.
select sysdate
2.
Using the SYSDATE function: return the current date from the system
3.
Get current operating system date
4.
Combining TO_CHAR to Format SYSDATE
5.
Removing the Time from SYSDATE
6.
Truncating to the Quarter
7.
Adding Two Months to SYSDATE
8.
Adding One Month a certain date
9.
Finding the First Monday After the Current Date and Time
10.
use sysdate to init a variable
11.
Minus days from sysdate