none
time selection RRS feed

  • Question

  • in datatimepicker ,set format = time and showupdown=true
    in database,i have inserted time from datatimepicker
    forexample
    1/1/1900 5:16:52 PM in database

    from application (vb.net or c#.net) ,i want to pass query, to select between two time

    how can i do

     

    "select d.qty as qty,d.amt as amt,d.dtime as time,d.date as date from invoice iv inner Join ( select tra.idate as date,tra.itime as dtime from invtran tra where (tra.idate>='" & CDate(dtp1.Value.Date) & "' and tra.idate<='" & CDate(dtp2.Value.Date) & "' ) and (tra.itime>=" & tm1.Value.TimeOfDay & " and tra.itime<= " & t2.Value.TimeOfDay & " ) ) d on iv.invno=d.invno"
    ''
    do not privide me result

     

     


     

    Sunday, October 18, 2009 10:20 AM

Answers

All replies