A script to find bad dates in the database
- This script detects all possible date columns that might have Y2K mistakes in a database. The unique thing about this is that it tries to be as efficient as possible by using indexes and/or selecting all date columns at the same time from a given table. Note that is only identifies suspect data; it assumes that any data earlier than 1950 is suspect. You should modify the query to suit your environment.
(Added: 21-Nov-1999 Hits: 4755 Rating: 6.00 Votes: 4) Rate It
DATEADD
- Returns a new datetime value based on adding an interval to the specified date. Syntax DATEADD ( datepart , number, date ) examples 1)Subtract 10 days from '05/APR/2004' Select DateADD('dd' , -10, to_date('05/APR/2004')) from dual ------------ 03/26/2004
(Added: 6-Apr-2004 Hits: 2900 Rating: 5.33 Votes: 6) Rate It
DateAdd function Oracle
- Get a new date based in interval parameter.
(Added: 30-Jul-2008 Hits: 2043 Rating: 0 Votes: 0) Rate It
DateDiff Function
- Determine the elapsed time between two dates stated in a specific interval.
(Added: 22-May-2007 Hits: 3931 Rating: 4.00 Votes: 2) Rate It
monthcal.sql
- Generates a online calendar of any month of any year based on values of month/year provided by the user. It runs well for any Oracle system environment.
(Added: 31-Oct-2003 Hits: 3694 Rating: 1.00 Votes: 1) Rate It
Read values one by one at a time from a string separated by
- This script is used to read one value at a time from a given string separated by ",". Works just like a C array program. Can use be use in the applications where input is in the form of string and during SQL join condition one needs to use single value.
(Added: 2-Apr-2001 Hits: 3325 Rating: 2.00 Votes: 2) Rate It
Week number calculation
- This script returns week numbers in current year
(Added: 21-Apr-2005 Hits: 2603 Rating: 1.67 Votes: 3) Rate It
