coba di cek datanya, apa formatnya sudah ok? atau coba cek code ini :
to_date(created_ date,'YYYY-<spasi>MM-DD') mungkin seharusnya to_date(created_ date,'YYYY-MM-DD') ? regards, pandu wp --- On Wed, 3/11/09, dryora <[email protected]> wrote: From: dryora <[email protected]> Subject: [indo-oracle] order by to_date() error ORA-01830 To: [email protected] Date: Wednesday, March 11, 2009, 9:14 PM Dear All gue ada sedikit masalah neh.... mohon pencerahannya. .. gue punya query yang didalamnya ada function to_date select ecn_no, substr(subject, 0,95), apply_date, to_date(created_ date,'YYYY- MM-DD') mydate from rndp_ecn_master where 1=1 and status = 'COMPLETED' order by mydate gue juga udah coba ganti *order by mydate* dengan o*rder by to_date(created_ date,'YYYY- MM-DD')* kenapa error yah ketika gue order by ? Oracle Error :: ORA-01830 date format picture ends before converting entire input string sebagai info : tipe data *created_date* adalah varchar2 tp kalo ga di order by, everything is fine Mohon Pencerahannya Makasih [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
