GridGain Developers Hub
GitHub logo GridGain iso GridGain.com
GridGain Software Documentation

Date and Time Functions

CURRENT_DATE

{CURRENT_DATE [()] | CURDATE() | SYSDATE | TODAY}

Description

Returns the current date. This method always returns the same value within a transaction.

Examples

CURRENT_DATE()

CURRENT_TIME

{CURRENT_TIME [ () ] | CURTIME()}

Description

Returns the current time. This method always returns the same value within a transaction.

Examples

CURRENT_TIME()

CURRENT_TIMESTAMP

{CURRENT_TIMESTAMP [([int])] | NOW([int])}

Description

Returns the current timestamp. The precision parameter for nanoseconds precision is optional. This method always returns the same value within a transaction.

Examples

CURRENT_TIMESTAMP()

DATEADD

{DATEADD| TIMESTAMPADD} (unitString, addIntLong, timestamp)

Description

Adds units to a timestamp. The string indicates the unit. Use negative values to subtract units. addIntLong may be a long value when manipulating milliseconds, otherwise its range is restricted to int. The same units as in the EXTRACT function are supported. The DATEADD method returns a timestamp. The TIMESTAMPADD method returns a long.

Examples

DATEADD('MONTH', 1, DATE '2001-01-31')

DATEDIFF

{DATEDIFF | TIMESTAMPDIFF} (unitString, aTimestamp, bTimestamp)

Description

Returns the number of crossed unit boundaries between two timestamps. This method returns a long. The string indicates the unit. The same units as in the EXTRACT function are supported.

Examples

DATEDIFF('YEAR', T1.CREATED, T2.CREATED)

DAYNAME

DAYNAME(date)

Description

Returns the name of the day (in English).

Examples

DAYNAME(CREATED)

DAY_OF_MONTH

DAY_OF_MONTH(date)

Description

Returns the day of the month (1-31).

Examples

DAY_OF_MONTH(CREATED)

DAY_OF_WEEK

DAY_OF_WEEK(date)

Description

Returns the day of the week (1 means Sunday).

Examples

DAY_OF_WEEK(CREATED)

DAY_OF_YEAR

DAY_OF_YEAR(date)

Description

Returns the day of the year (1-366).

Examples

DAY_OF_YEAR(CREATED)

EXTRACT

EXTRACT ({EPOCH | YEAR | YY | QUARTER | MONTH | MM | WEEK | ISO_WEEK
| DAY | DD | DAY_OF_YEAR | DOY | DAY_OF_WEEK | DOW | ISO_DAY_OF_WEEK
| HOUR | HH | MINUTE | MI | SECOND | SS | MILLISECOND | MS
| MICROSECOND | MCS | NANOSECOND | NS}
FROM timestamp)

Description

Returns a specific value from a timestamps. This method returns an int.

Examples

EXTRACT(SECOND FROM CURRENT_TIMESTAMP)

FORMATDATETIME

FORMATDATETIME (timestamp, formatString [,localeString [,timeZoneString]])

Description

Formats a date, time, or timestamp as a string. The most important format characters are: y year, M month, d day, H hour, m minute, s second. For details about the format, see java.text.SimpleDateFormat. This method returns a string.

Examples

FORMATDATETIME(TIMESTAMP '2001-02-03 04:05:06', 'EEE, d MMM yyyy HH:mm:ss z', 'en', 'GMT')

HOUR

HOUR(timestamp)

Description

Returns the hour (0-23) from a timestamp.

Examples

HOUR(CREATED)

MINUTE

MINUTE(timestamp)

Description

Returns the minute (0-59) from a timestamp.

Examples

MINUTE(CREATED)

MONTH

MONTH(timestamp)

Description

Returns the month (1-12) from a timestamp.

Examples

MONTH(CREATED)

MONTHNAME

MONTHNAME(date)

Description

Returns the name of the month (in English).

Examples

MONTHNAME(CREATED)

PARSEDATETIME

PARSEDATETIME(string, formatString [, localeString [, timeZoneString]])

Description

Parses a string and returns a timestamp. The most important format characters are: y year, M month, d day, H hour, m minute, s second. For details about the format, see java.text.SimpleDateFormat.

Examples

PARSEDATETIME('Sat, 3 Feb 2001 03:05:06 GMT', 'EEE, d MMM yyyy HH:mm:ss z', 'en', 'GMT')

QUARTER

QUARTER(timestamp)

Description

Returns the quarter (1-4) from a timestamp.

Examples

QUARTER(CREATED)

SECOND

SECOND(timestamp)

Description

Returns the second (0-59) from a timestamp.

Examples

SECOND(CREATED)

WEEK

WEEK(timestamp)

Description

Returns the week (1-53) from a timestamp. This method uses the current system locale.

Examples

WEEK(CREATED)

YEAR

YEAR(timestamp)

Description

Returns the year from a timestamp.

Examples

YEAR(CREATED)