Oracle PL/SQL: Date Functions: WHERE Clause Joins - Examples of using dates in WHERE Clause Joins.

Quick Search:

Oracle PL/SQL: Date Functions: WHERE Clause Joins

Jump to:

Category: >> Oracle PL/SQL >> Date Functions: WHERE Clause Joins

<< last

next >>

Snippet Name: Date Functions: WHERE Clause Joins

Description: Examples of using dates in WHERE Clause Joins.

Also see:
» BR2NL Function: Opposite of NL2BR
» A JavaScript implementation of the fam...
» Call a PHP function when clicking on a...
» FUNCTIONS: Deterministic
» FUNCTIONS: Nested Functions
» FUNCTIONS: IF statement
» FUNCTIONS: date/time
» FUNCTIONS: Sample functions
» FUNCTIONS: drop
» FUNCTIONS: Recompile
» FUNCTIONS: DEBUG mode
» FUNCTIONS: IN OUT parameter
» FUNCTIONS: with output parameters
» FUNCTIONS: with parameters
» FUNCTIONS: without parameters
» FUNCTIONS: Create function
» FUNCTIONS: special restrictions
» FUNCTIONS: System Privileges
» Recursive fopen() function
» INDEXES: ENABLE (function-based index)
» INDEXES: DISABLE (function-based index)
» PACKAGES: one function
» INDEXES: Function-Based Index
» IN Function
» Built-In Functions: CASE
» Built-In Functions: DECODE
» Alternate Title Case function
» SELECT: Using Functions
» UPDATE: Update a partitioned table
» UPDATE: Update based on a record

Comment: (none)

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

SELECT SYSDATE FROM dual;
 
ALTER SESSION SET NLS_DATE_FORMAT = 'DD-MON-YYYY HH24:MI:SS';
 
SELECT SYSDATE FROM dual;
 
/
 
/
 
ALTER SESSION SET NLS_DATE_FORMAT = 'DD-MON-YYYY';
 
CREATE TABLE t (
datecol DATE);
 
INSERT INTO t
(datecol)
VALUES
(SYSDATE);
 
SELECT * FROM t;
 
ALTER SESSION SET NLS_DATE_FORMAT = 'DD-MON-YYYY HH24:MI:SS';
 
SELECT * FROM t;
 
ALTER SESSION SET NLS_DATE_FORMAT = 'DD-MON-YYYY';
 
SELECT * FROM t;
 
SELECT SYSDATE FROM dual;
 
SELECT * FROM t
WHERE datecol = SYSDATE;
 
ALTER SESSION SET NLS_DATE_FORMAT = 'DD-MON-YYYY HH24:MI:SS';
 
SELECT * FROM t;
 
SELECT SYSDATE FROM dual;
 
SELECT TRUNC(SYSDATE) FROM dual;
 
SELECT * FROM t
WHERE TRUNC(datecol) = TRUNC(SYSDATE);
 
ALTER SESSION SET NLS_DATE_FORMAT = 'DD-MON-YYYY';