SYSDATE ORACLE

 SQL>select TO_CHAR(sysdate, 'MM/DD/YYYY') CHRDATE from dual;

CHRDATE

---

11/14/2005

SQL>select TO_DATE(TO_CHAR(sysdate, 'MM/DD/YYYY'), 'MM/DD/YYYY') mydate from dual;

MYDATE

---

14-NOV-05

SQL>select TO_CHAR(sysdate, 'DD-Mon-YY') MYDATE from dual;

MYDATE

---

09-JAN-13
 
date.now = 2013-01-09
$tanggal=date('Y-m-d',strtotime('-1 day'));
echo $tanggal;

output:
2013-01-08