Rabu, 30 Mei 2012

Tugas Praktikum Sistem Basis Data



  • Anton Sumanjaya
  • 2010 4350 1220
  • S 4 O
  • Sistem Basis Data
  • Dosen  :  Nahot Prastian, S.Kom.
 Universtas Indraprasta PGRI

Membuat Data Base Fungsi Tunggal


1. ADDATE ()
 
2. CURDATE ()
 
 3. CURETIME ()
 
4. CURENT_TMESTAMP ()
 
5. DAY NAME

6. DAY OF MONTH

7. DAY OF YEAR
 
8. EXTRACT_DATE FORMAT

9. SELECT FROM DAY
10. SELECT FROM HOUR
 
11. SELECT FROM MINUTE

12. SELECT FROM SECOND 
13. SELECT FROM MONTH
14. SELECT FROM YEAR

15. SELECT NOW

16. SELECT DATA FORMAT