Quick Search:
 Oracle PL/SQL: Date Functions: SYSDATE Jump to:  
Category: >> Oracle PL/SQL >> Date Functions: SYSDATE  

<< 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 and Time Calculations: Get second...
» 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

-- Example syntax used with TO_CHAR and a format mask:
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

   Home |    Search |    Code Library |    Sponsors |    Privacy |    Terms of Use |    Contact Us © 2003 - 2024 psoug.org