7 Replies Latest reply: Jan 30, 2014 4:19 AM by Nirmal Raj RSS

    where clause for time

    Nick Gan

      Hi,

       

      I'm doing a simple where clause on sales_time

       

      Where sales_time < '11:59:59.000'

       

      sample of sales_time values

      02:39:14.000

      02:40:40.000

      02:47:32.000

      04:00:00.000

      04:01:28.000

      04:45:02.000

      04:50:00.000

      05:00:00.000

       

      and it returns 0 lines.

       

      i tried num(sales_time ) or time(sales_time) or timestamp(sales_time) or num(timestamp(sales_time)), none of it works.

       

      help please ....