Quick Search:
CODE
Oracle PL/SQL Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
 Oracle PL/SQL: Date Functions: SYSDATE Jump to:  
Category: >> Oracle PL/SQL >> Date Functions: SYSDATE Bookmark and Share

<< lastnext >>

Snippet Name: Date Functions: SYSDATE

Description: Returns the current date and time set for the operating system on which the database resides.

Also see:
» FUNCTIONS: date/time
» UPDATE: Update a partitioned table
» UPDATE: Update based on a record
» UPDATE: Update Object Table
» UPDATE: with RETURNING clause
» UPDATE: Nested Table Update example
» UPDATE: Correlated Update
» UPDATE: Update from a SELECT statement
» UPDATE: based on multiple returned val...
» UPDATE: Update based on a query
» UPDATE: Update multiple rows
» UPDATE: update a specific record
» UPDATE: Single row
» Date Functions: EXTRACT
» Date Functions: TO_DSINTERVAL
» Date Functions: TO_NCHAR
» Date Functions: TO_YMINTERVAL
» Date Functions: Calculate elapsed time...
» Date/Time Calculations: Get seconds be...
» Date: Find first day of the month
» Date Calculations
» Date Functions: WHERE Clause Joins
» Date Functions: TRUNC
» Date Functions: SYSDATE
» Date Functions: TO_CHAR
» Date Functions: ROUND
» Date Functions: NEXT_DAY
» Date Functions: NEW_TIME
» Date Functions: MONTHS_BETWEEN
» Date Functions: MIN

Comment: (none)

Language: PL/SQL
Highlight Mode: PLSQL
Last Modified: March 03rd, 2009

SYSDATE
 
SELECT SYSDATE FROM dual;
 
-- Example syntax used with TO_CHAR and a format mask:
SELECT TO_CHAR(SYSDATE, <format mask>) FROM DUAL;
 
SELECT TO_CHAR(SYSDATE,'DDD')"Today" FROM DUAL;
 
 
/*
 
Format Mask Definitions:
 
 - D: Day of the week
 - DD: Day of the month
 - DDD: Numerical day of the year, 1 ~ 365 (366 for Leap years)
 - DAY: Full textual representation of the day, i.e. "Monday", "Tuesday", "Wednesday"
 - DY: Day in three letters, i.e. "MON", "TUE", "FRI"
 - W: Week of the month
 - WW: Week of the year
 - MM: Month in two digits, i.e. 01 = Jan, 02 = Feb,...12 = -Dec
 - MON: Month in three characters, i.e. "Jan", "Feb", "Apr"
 - MONTH: Full textual representation of the Month, i.e. "January", "February", "April"
 - RM: Month in Roman Characters (I-XII, I-Jan, II-Feb,...XII-Dec)
 - Q: Quarter of the Month
 - YY: Last two digits of the year.
 - YYYY: Full year
 - YEAR: Year in words like "Nineteen Eighty Seven"
 - HH: Hours in 12 hour format 
 - HH12: Hours in 12 hour format
 - HH24: Hours in 24 hour format ("military time")
 - MI: Minutes
 - SS: Seconds
 - FF: Fractional Seconds
 - SSSSS: Milliseconds
 - J: Julian Day i.e Days since 1-Jan-4712BC to till-date
 - RR: If the year is less than 50 then Oracle considers the year 
   as a 21st century date. If the year is greater than 50 then Oracle 
   considers the year to be in the 20th century
 
*/


Free
Oracle Magazine
Subscriptions
and Oracle White Papers


SQL University.net courses meet the most demanding needs of the business world for advanced education in a cost-effective manner. SQL University.net courses are available immediately for IT professionals and can be taken without disruption of your workplace schedule or processes.

Compared to traditional travel-based training, SQL University.net saves time and valuable corporate resources, allowing companies to do more with less. That's our mission, and that's what we deliver.

Click here to find out more
 
Home      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us 255 users online    © 2009 psoug.org

PSOUG LOGIN
Username: 
Password: 
Forgot your password?