Logo

Go on. Explore!

lvl 0 • 0 xp

lvl 1

HomeMarketDecksInterests
SQL

SQL

memorize.aimemorize.ai (lvl 286)
Star 0%
Star 0%
Star 0%
Star 0%
Star 0%
(0)
(0)
(0)
17 cards
()
Section 1

Preview this deck

LAST_DAY(date)

Front

1 / 17

SQL
Star 0%
Star 0%
Star 0%
Star 0%
Star 0%

0.0

0 reviews

5
0
4
0
3
0
2
0
1
0

Active users

0

All-time users

0

Favorites

0

Last updated

6 years ago

Date created

Mar 14, 2020

Cards (17)

Section 1

(17 cards)

LAST_DAY(date)

Front

returns the date of the last day of the month that contains date

Back

TO_DATE(char [, fmt [, 'nlsparam' ] ])

Front

converts a formatted TEXT or NTEXT expression to a DATETIME value

Back

NS: IS NULL

Front

NS: Display "Unassigned" in results if blank

Back

TO_CHAR({ datetime | interval } [, fmt [, 'nlsparam' ] ])

Front

converts a datetime or interval value to a value of VARCHAR2 datatype in the format specified by the date format fmt

Back

TRUNC(date [, fmt ])

Front

returns date with the time portion of the day truncated to the unit specified by the format model fmt

Back

NS: NULLIF

Front

NS To avoid divide by zero errors: if result is zero, replace with null

Back

CASE { expr WHEN comparison_expr THEN return_expr [ WHEN comparison_expr THEN return_expr ]... | WHEN condition THEN return_expr [ WHEN condition THEN return_expr ]... } [ ELSE else_expr ] END

Front

Returns value based on different conditions

Back

DECODE(expr, search, result [, search, result ]... [, default ])

Front

Compares expr to each search value one by one. If expr is equal to a search, the corresponding result is returned. If no match is found, default is returned

Back

NS: DECODE

Front

NS: Compares 2 values, then returns specified parameter if they match

Back

NS: CASE

Front

NS: RETURNS VALUE BASED ON DIFFERENT CONDITIONS

Back

ADD_MONTHS(date, integer)

Front

returns the date plus integer months

Back

NULLIF

Front

Compares expr1 and expr2. If they are equal, then the function returns null. If they are not equal, then the function returns expr1

Back

NEXT_DAY(date, char)

Front

returns the date of the first weekday named by char that is later than the date

Back

ROUND(date [, fmt ])

Front

returns date rounded to the unit specified by the format model fmt

Back

NS: TO CHAR

Front

NS: display date by day of the week

Back

MONTHS_BETWEEN(date1, date2)

Front

returns the number of months between date1 and date2

Back

TO_CHAR({ datetime | interval } [, fmt [, 'nlsparam' ] ])

Front

converts a datetime or interval value to a value of VARCHAR2 datatype in the format specified by the date format fmt

Back