Reading...
Play button
Play button
Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
4 Cards in this Set
- Front
- Back
- 3rd side (hint)
|
Datetime datatypes
|
- Date
- Timestamp - Interval Days since 1-Jan-4712 BC - decimal portion is fraction of day |
3 types
- plus base time for starting # of days |
|
|
Diff in ROUND and TRUNC
|
ROUND (n1, n2)
TRUNC (n1, n2) |
|
|
|
Diff in MOD() and REM()
|
MOD(n1/n2) uses...
REM(nt/n2) uses... |
|
|
|
SYSDATE
|
- no args and returns current date/time for operating-system host where database resides
- result will be the same for all users, regardless of location that are on system |
- any args
- date/time for client/server/host? |
