SQL Date and Time Functions
Topics:
CURRENT_DATE: Obtaining the Date
CURRENT_TIME: Obtaining the Time
CURRENT_TIMESTAMP: Obtaining the Timestamp (Date/Time)
DAY: Obtaining the Day of the Month From a Date/Timestamp
DAYS: Obtaining the Number of Days Since January 1, 0001
EXTRACT: Obtaining a Datetime Field From Date/Time/Timestamp
HOUR: Obtaining the Hour From Time/Timestamp
MICROSECOND: Obtaining Microseconds From Time/Timestamp
MILLISECOND: Obtaining Milliseconds From Time/Timestamp
MINUTE: Obtaining the Minute From Time/Timestamp
MONTH: Obtaining the Month From Date/Timestamp
SECOND: Obtaining the Second Field From Time/Timestamp
QUARTER: Returning the Quarter of the Year
WEEKDAY: Returning the Day of the Week
YEAR: Obtaining the Year From a Date or Timestamp
SQL date and time functions perform manipulations on date and time values.
iWay Software