SQL> select to_char(sysdate,''''yyyy.mm.dd''''),to_char((sysdate)+1,''''yyyy.mm.dd'''') from dual;
347
348TO_CHAR(SY TO_CHAR((S
349---------- ----------
3502004.05.09 2004.05.10
351SQL> select last_day(sysdate) from dual;
352
353LAST_DAY(S
354----------
35531-5月 -04
356
357
35838.MONTHS_BETWEEN(date2,date1)
359给出date2-date1的月份
360SQL> select months_between(''''19-12月-1999'''',''''19-3月-1999'''') mon_between from dual;
361
362MON_BETWEEN
363-----------
364 9
365SQL>selectmonths_between(to_date(''''2000.05.20'''',''''yyyy.mm.dd''''),to_date(''''2005.05.20'''',''''yyyy.mm.dd'''')) mon_betw from dual;
366
367 MON_BETW
368---------
369 -60
370
371
37239.NEW_TIME(date,''''this'''',''''that'''')
373给出在this时区=other时区的日期和时间
374SQL> select to_char(sysdate,''''yyyy.mm.dd hh24:mi:ss'''') bj_time,to_char(new_time
375 2 (sysdate,''''PDT'''',''''GMT''''),''''yyyy.mm.dd hh24:mi:ss'''') los_angles from dual;
376
377BJ_TIME LOS_ANGLES
378------------------- -------------------
3792004.05.09 11:05:32 2004.05.09 18:05:32
380
381
38240.NEXT_DAY(date,''''day'''')
383给出日期date和星期x之后计算下一个星期的日期
384SQL> select next_day(''''18-5月-2001'''',''''星期五'''') next_day from dual;
385
386NEXT_DAY
387----------
38825-5月 -01
389
390
391
39241.SYSDATE
393用来得到系统的当前日期
394SQL> select to_char(sysdate,''''dd-mm-yyyy day'''') from dual;
395
396TO_CHAR(SYSDATE,''''
397-----------------
39809-05-2004 星期日
399trunc(date,fmt)按照给出的要求将日期截断,如果fmt=''''mi''''表示保留分,截断秒
400SQL> select to_char(trunc(sysdate,''''hh''''),''''yyyy.mm.dd hh24:mi:ss'''') hh,
401 2 to_char(trunc(sysdate,''''mi''''),''''yyyy.mm.dd hh24:mi:ss'''') hhmm from dual;
402
403HH HHMM
404------------------- -------------------
4052004.05.09 11:00:00 2004.05.09 11:17:00
406
407
408
40942.CHARTOROWID
410将字符数据类型转换为ROWID类型
411SQL> select rowid,rowidtochar(rowid),ename from scott.emp;
412
413ROWID ROWIDTOCHAR(ROWID) ENAME
414------------------ ------------------ ----------
415AAAAfKAACAAAAEqAAA AAAAfKAACAAAAEqAAA SMITH
416AAAAfKAACAAAAEqAAB AAAAfKAACAAAAEqAAB ALLEN
417AAAAfKAACAAAAEqAAC AAAAfKAACAAAAEqAAC WARD
418AAAAfKAACAAAAEqAAD AAAAfKAACAAAAEqAAD JONES
419
420
42143.CONVERT(c,dset,sset)
422将源字符串 sset从一个语言字符集转换到另一个目的dset字符集
423SQL> select convert(''''strutz'''',''''we8hp'''',''''f7dec'''') "conversion" from dual;
424
425conver
426------
427strutz
428上一页 [1] [2] [3] [4] [5] [6] [7] [8] [9] [10] 下一页 |
