| |
Date functions in sql
Math functions
Number based functions
Rounding number
Truncing numbers
remainder for a division
select round( 95.926,2),trunc( 95.926 ,2), mod( 16,3) from dual
select round( 95.926,2),trunc( 95.926 ,2), mod( 16,3) from dual
select sysdate from dual
select to_char(sysdate, 'MM-DD RRRR'),to_char(sysdate, 'MM/DD/yyyy') from dual
select to_char(sysdate, 'RRRR/MM/DD'),to_char(sysdate, ' yyyy') from dual
select to_char(sysdate, 'RRRR-MM_DD'),to_char(sysdate, ' yyyy MM DD') from dual
select (to_date('04/13/2009', 'mm/dd/rrrr')-to_date('04/14/2010','mm/dd/rrrr'))as " number of days" from dual
select sysdate+10 from dual
select months_between(sysdate, '11-Jan-94') from dual
select add_months(sysdate, 6) from dual
select next_day(sysdate, 'MONDAY') from dual
select next_day(sysdate, 'TUESDAY') from dual
select next_day(sysdate, 'SUNDAY') from dual
select last_day(sysdate) from dual
select round(sysdate, 'MONTH') from dual
select round(sysdate,'YEAR'),trunc(sysdate,'YEAR') from dual
select round(to_date('05/07/09','mm/dd/rr'), 'YEAR') ,round(to_date('07/07/09','mm/dd/rr'), 'YEAR')from dual
select to_char(sysdate, 'RRRR ') from dual
select to_char(sysdate, 'YYYY'),to_char(sysdate, 'RR') from dual
select to_char(sysdate, 'YY') from dual
select to_char(sysdate,'DY MON YYYY HH:MI:SS AM'), to_char(sysdate,'DAY DD /MONTH /YEAR HH24:MI:SS AM'),
to_char(sysdate,' DD "of" Month') , to_char(sysdate-10,' ddspTH "of" Month'),to_char(sysdate-10,' DDspTH "of" Month')from dual
Please send comments to vgdarur.javafive@blogger.com
|
