Examples for validating dates in pl sql malcolm x dedating


Examples for validating dates in pl sql

The landmark book "Advanced Oracle SQL Tuning The Definitive Reference" is filled with valuable information on Oracle SQL Tuning.

This book includes scripts and tools to hypercharge Oracle 11g performance and you can buy it for 30% off directly from the publisher.

The dates have been adjusted where necessary to show the difference between the return values of the functions.

SELECT SYSDATE, TRUNC(SYSDATE, 'CC'), ROUND(SYSDATE, 'CC') FROM dual; SYSDATE TRUNC(SYSDATE,'CC') ROUND(SYSDATE,'CC') -------------------- -------------------- -------------------- 16-JAN-1999 01-JAN-1901 01-JAN-2001 1 row selected.

SQL That string looks perfectly acceptable to me, because I understand the variations in date formats and that looks like a UK representation of "27th April 2013" to me, but the database doesn't know that.