Skip to content

Instantly share code, notes, and snippets.

@sakti

sakti/umur.sql

Created December 21, 2010 11:33
Show Gist options
  • Save sakti/749825 to your computer and use it in GitHub Desktop.
Save sakti/749825 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
umur.sql
SELECT DATE_FORMAT(NOW(), '%Y') - DATE_FORMAT(tgl_lahir, '%Y') - (DATE_FORMAT(NOW(), '00-%m-%d') < DATE_FORMAT(tgl_lahir, '00-%m-%d'))
AS umur
FROM mahasiswa
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment