CODEWITHSUNDEEP
sqloracle-database
user2254180
user2254180

Reputation: 856

Get Records By Todays Date And Before Current Time

I am trying to query some records and am looking to return only records that have a date of today, but also are before the current time.

I have the first part sorted out by using the following clause to return only records for today.

WHERE TRUNC(my_date_time) = TRUNC(sysdate)

How would I modify this to only get records before the current system time as well?

Upvotes: 0

Views: 773

Answers (3)

Himanshu
Himanshu

Reputation: 3970

Try this. 

    Select * from table   Where  
     TRUNC(my_date_time) = 
    TRUNC(sysdate) And 
     TO_CHAR(my_date_time, 
      'HH24:MI:SS' ) <= 
      TO_CHAR(sysdate, 
      ' HH24:MI:SS' )

enter image description here

Upvotes: -1

alvalongo
alvalongo

Reputation: 571

If column "my_date_time" is of type DATE, and need compare using SYSDATE function then you only need:

WHERE my_date_time<=sysdate

If column "my_date_time" is of type DATE, and need compare with other variable or column of type DATE for example named "other_date"

 where my_date_time>=trunc(other_date)
   and my_date_time<trunc(other_date)+1

Upvotes: -2

Gordon Linoff
Gordon Linoff

Reputation: 1269783

How about inequalities?

WHERE my_date_time >= TRUNC(sysdate) AND
      my_date_time < sysdate

Upvotes: 4

Related Questions