> Hi all, > > I have confused with my problem about compare value in time format. > > I will simplify with this format > > We have table tarif with structure like this > > MULAI_WAKTU TIME, > SELESAI_WAKTU TIME, > ZONA VARCHAR(3) > > and have Store Proc like this > > CREATE PROCEDURE TESTING > AS > declare variable jam time; > declare variable MULAI_WAKTU1 time; > declare variable SELESAI_WAKTU2 time; > > > BEGIN > jam = current_time; > > for > Select mulai_waktu, selesai_waktu > from tarif > where tarif.zona = 'Z2' > and tarif.libur = 'T' > and ( tarif.mulai_waktu <= :jam ) <-- error in conversion jam variable > and ( tarif.selesai_waktu >= :jam ) <-- > > into > :mulai_waktu1, :selesai_waktu2 > > do suspend; > END > > Just execute this proc and give me conversion error. > > But, we replace :jam with current_time, this sP will execute with > no errors. > > This is make me confused, althought jam have a time type field. > Why passing variable with time field can't compare in where > section ? I miss something ... ? > > thanks > Bayu
------------------------ Yahoo! Groups Sponsor ---------------------~--> Flexible Keyboard is the ideal accessory for PDA users that are on the move. http://us.click.yahoo.com/dCBVZC/WnCFAA/sXBHAA/i7folB/TM ---------------------------------------------------------------------~-> Berlangganan: [EMAIL PROTECTED] Stop Berlangganan: [EMAIL PROTECTED] Keluhan Milis(Unbouncing,spam,dll): [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
