Highlights
All Snippets
Top 100 Snippets
Librarians
gbCodeLib

By Language
VB6
JavaScript
Perl
HTML
SQL
Java
DOS

GBIC >> Source Code >> SQL >> Snippet

05 Functions - Date and Time


ADD_MONTHS:   adds a NUMBER OF months TO a specified DATE

LAST_DAY:    returns the LAST DAY OF a specified MONTH

MONTHS_BETWEEN: how many months fall BETWEEN MONTH x AND MONTH y

NEW_TIME:    adjust the TIME according TO the TIME ZONE you ARE IN

NEXT_DAY   finds the NAME OF the FIRST DAY OF the week that IS equal TO OR later than another specified DATE

SYSDATE   returns the system TIME AND DATE :