10 Replies Latest reply: Jun 20, 2014 6:13 AM by BluShadow RSS

    comparing date and time columns

    894248

      Hi,

       

      Please help me with fetching the records with date>= 20-06-2014  and Time >= 16:00:00. The expected output in this case is last 2 records.

      ID

      date

      Time

      1

      15-06-2014

      12:20:15

      2

      16-06-2014

      20:15;21

      3

      20-06-2014

      15:10:25

      4

      20-06-2014

      16:10:30

      5

      20-06-2014

      18:15:45

       

      Thanks,

      Arjun