Re: [indo-oracle] Tanya SQL

[Ane Oracle]

 SELECT CONCAT((concat(sysdate,', APL ')),concat(u.NAMA_UP,' (Lembar,RpTag):
')) AS KET
FROM Fajar.LOG_TRANSAKSI l , Fajar.UP u
WHERE l.KDLUNAS='1' AND SUBSTR(l.KDPP,8,5)=U.UNITUP AND SUBSTR(l.KDPP,8,5)=
54220
AND TGLLUNAS=to_date('02/06/1992','dd/mm/yyyy')
GROUP BY TGLLUNAS,NAMA_UP

On 7/10/07, Sufajar B <[EMAIL PROTECTED]> wrote:
>
>   Salam semuanya.
> saya adl anggota baru di milist ini dan baru juga belajar oracle.
> saya mo tanya saya punya sql sbb:
>
> SELECT CONCAT((concat(sysdate,', APL ')),concat(u.NAMA_UP,'
> (Lembar,RpTag): ')) AS KET
> FROM Fajar.LOG_TRANSAKSI l , Fajar.UP u
> WHERE l.KDLUNAS='1' AND SUBSTR(l.KDPP,8,5)=U.UNITUP AND SUBSTR(l.KDPP,8,5)=
> 54220
> AND TGLLUNAS='02/06/1992'
> GROUP BY TGLLUNAS,NAMA_UP
>
> setelah saya jalan kan muncul erorr sbb:
>
> ORA - 01843 : NOT A VALID MONTH
>
> apanya yg salah ??
> padahal tanggal '02/06/1992' ada di dalam tabel.
>
> atas bantuan teman2 semua ane ucapkan terimakasih.
>
> ~salam anggota baru ~
>
> ---------------------------------
> Looking for a deal? Find great prices on flights and hotels with Yahoo!
> FareChase.
>
> [Non-text portions of this message have been removed]
>
>  
>


[Non-text portions of this message have been removed]