Tuesday, June 22, 2010

beberapa fungsi dlam mysql

pembulatan bilanagan real

select round(field,0) from table

contoh

select round(gaji*1.1,0) from pegawi;


mencari umur
select nama, round(DateDiff(Now(),tgl_lahir)/365,0) from pribadi;


No comments: