SELECT * FROM NAMA_TABLE
WHERE TO_CHAR('15/07/2006','mm/yyyy') = TO_CHAR('15/07/2006','mm/yyyy')
ubah 15/07/2006 --> '15/07/2006'> Saya sudah coba sbb: > SELECT * FROM NAMA_TABLE > WHERE TO_CHAR(15/07/2006,'mm/yyyy') = TO_CHAR(15/07/2006,'mm/yyyy') > > Malah dapat ORA-01756 > > Mungkin ada kesalahan dalam query saya? -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [EMAIL PROTECTED] Website: http://indo-oracle.blogspot.com Mirror: http://indooracle.wordpress.com ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.blogspot.com Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indo-oracle/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
