OracleDatabase DateTime

1. `TO_CHAR`

SELECT TO_CHAR(SYSDATE, 'YYYY-MM-DD HH24:MI:SS') FROM DUAL -- 2014-08-18 02:18:17

D - Day of week (1-7).

2. `DATE` `BETWEEN`

SELECT
	FROM TABLE_NAME
	WHERE
		DATE_FIELD BETWEEN (TO_DATE('2014-08-31', 'YYYY-MM-DD')) AND TO_DATE('2014-08-31', 'YYYY-MM-DD') + 1 - (1/(24*60*60))

3. Generate date list

SELECT TO_DATE('2014-10-23', 'YYYY-MM-DD') + LEVEL
    FROM DUAL
    CONNECT BY LEVEL < TO_DATE('2014-10-23', 'YYYY-MM-DD') - TO_DATE('2013-10-23', 'YYYY-MM-DD')

5. See Also

5.1. Backlinks

5.2. Similar Pages

Similar pages by cosine similarity. Words after page name are term frequency.

60.77% JavaScriptDateTime date(10:51), mm(6:12), yyyy(6:8), time(1:12), format(1:11), dd(6:5), ss(1:7), day(1:6), and(1:4), web(1:1)
51.93% MySQLDateTime date(10:21), format(1:7), select(3:3), day(1:3), time(1:3), week(1:2), field(1:1), and(1:1), where(1:1)
49.04% jQueryUIDatePicker date(10:27), mm(6:3), dd(6:3), format(1:7), day(1:4), select(3:2), from(3:1), week(1:1)
48.45% date date(10:9), time(1:1), pages(1:1), format(1:1)
46.63% DateTime date(10:9), time(1:8), database(1:1), oracle(1:1)
45.66% JavaDateTime date(10:2), mm(6:1), yyyy(6:1), related(1:1), ss(1:1), time(1:1), pages(1:1), web(1:1), format(1:1)
39.81% CSharpDateTime date(10:4), mm(6:4), dd(6:2), yyyy(6:2), format(1:2), ss(1:2), time(1:1)
36.53% PhpDateTime date(10:3), time(1:1)
35.65% ISO 8601 mm(6:6), date(10:1), yyyy(6:4), dd(6:3), related(1:1), week(1:1), and(1:1), time(1:1), pages(1:1), format(1:1)

5.3. Adjacent Pages

0 More

OracleDatabase DateTime

1. TO_CHAR

2. DATE BETWEEN

3. Generate date list

4. Related Web Pages

5. See Also

5.1. Backlinks

5.2. Similar Pages

5.3. Adjacent Pages

Aha00a

1. `TO_CHAR`

2. `DATE` `BETWEEN`