equal
deleted
inserted
replaced
270 List of Oracle Reserved Words. |
270 List of Oracle Reserved Words. |
271 ============================== |
271 ============================== |
272 |
272 |
273 * http://docs.oracle.com/cd/B19306_01/em.102/b40103/app_oracle_reserved_words.htm |
273 * http://docs.oracle.com/cd/B19306_01/em.102/b40103/app_oracle_reserved_words.htm |
274 |
274 |
|
275 Find time zone |
|
276 ============== |
|
277 |
|
278 Set TZ data formt:: |
|
279 |
|
280 alter session set 'YYYY-MM-DD HH24:MI:SS.FF3 TZR'; |
|
281 |
|
282 For system TZ look to TZ in:: |
|
283 |
|
284 select SYSTIMESTAMP from dual; |
|
285 |
|
286 For session TZ look to TZ in:: |
|
287 |
|
288 select CURRENT_TIMESTAMP from dual; |
|
289 |
|
290 or directly in:: |
|
291 |
|
292 select SESSIONTIMEZONE from dual; |
|
293 |
|
294 You can adjust session TZ by:: |
|
295 |
|
296 alter session set TIME_ZONE ='+06:00'; |
|
297 |
|
298 which affect on ``CURRENT_DATE``, ``CURRENT_TIMESTAMP``, ``LOCALTIMESTAMP``. |
|
299 |
|
300 ``DBTIMEZONE`` is set when database is created and can't be altered if the |
|
301 database contains a table with a ``TIMESTAMP WITH LOCAL TIME ZONE`` column and |
|
302 the column contains data:: |
|
303 |
|
304 select DBTIMEZONE from dual; |
|
305 |
|
306 Find time at timezone:: |
|
307 |
|
308 select SYSTIMESTAMP at time zone 'GMT' from dual; |
|
309 |
275 Adjust date format. |
310 Adjust date format. |
276 =================== |
311 =================== |
277 :: |
312 :: |
278 |
313 |
279 column parameter format a32; |
314 column parameter format a32; |
282 |
317 |
283 alter session set NLS_DATE_FORMAT = 'yyyy-mm-dd HH:MI:SS'; |
318 alter session set NLS_DATE_FORMAT = 'yyyy-mm-dd HH:MI:SS'; |
284 alter session set NLS_TIMESTAMP_FORMAT = 'MI:SS.FF6'; |
319 alter session set NLS_TIMESTAMP_FORMAT = 'MI:SS.FF6'; |
285 alter session set NLS_TIME_FORMAT = 'HH24:MI:SS.FF6'; |
320 alter session set NLS_TIME_FORMAT = 'HH24:MI:SS.FF6'; |
286 |
321 |
|
322 alter session set TIME_ZONE = '+06:00'; |
|
323 |
287 select sysdate from dual; |
324 select sysdate from dual; |
288 |
325 |
289 Working with SQL/Plus. |
326 Working with SQL/Plus. |
290 ====================== |
327 ====================== |
291 |
328 |