*********************** Your mail has been scanned by InterScan. PT. AJ Central Asia Raya ***********-***********
Tks atas advisenya Pak Andrew 'n Pak Rajiman Akhirnya saya pake cara ubah SP dari CREATE PROCEDURE sp_abcd @from char(10), @to char(10) Menjadi CREATE PROCEDURE sp_abcd @from datetime, @to datetime. Setelah datawindownya jadi, SP-nya saya balikin lagi ke CREATE PROCEDURE sp_abcd @from char(10), @to char(10) Setelah itu sudah bisa ...... PS : Buat Pak Ruthdie salam kenal, saya ini cewek :D Thanx Seluya ________________________________ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Andrew Sent: Thursday, April 19, 2007 4:08 PM To: [email protected] Subject: Re: [indopb] error converting datetime from character string coba deh pake format YYYY/MM/DD, di script PB kamu, gak perlu rubah2 regional seting. baik di client or server. :) ----- Original Message ----- From: Seluya <mailto:[EMAIL PROTECTED]> To: [email protected] <mailto:[email protected]> Sent: Thursday, April 19, 2007 2:54 PM Subject: [indopb] error converting datetime from character string *********************** Your mail has been scanned by InterScan. PT. AJ Central Asia Raya ***********-*********** Guys nanya donk ...... Saya menggunakan PB8, database SQL 2000 Saya create SP, lalu jadiin data window ... sudah dicompile dan berhasil. SP berisi script seperti berikut CREATE PROCEDURE sp_abcd @from char(10), @to char(10) AS Select * from A where tanggal between convert(datetime,@from,103) and convert(datetime,@to,103) Passing parameternya @from = '01/03/2007' @to = '31/03/2007' Dengan stored procedure yang sama, saya mau create data window lagi. Muncul error "Syntax error converting datetime from character string. 1 execute sp_abcd ; 1 @from = :from, @to = :to " Kalau saya create data window dengan menggunakan syntax SQL Select (bukan memilih Stored procedure) Select * from A where tanggal between convert(datetime,@from,103) and convert(datetime,@to,103) Data windownya sukses ..... Untuk regional setting saya menggunakan dd/mm/yyyy sedangkan di server menggunakan regional setting 'mm/dd/yyyy' Tapi saya sudah coba mengganti regional setting menjadi mm/dd/yyyy tetep muncul error. Kenapa yah bisa muncul error seperti itu ? Thanx Seluya
