SQL Query help

[Nalla_Balu]

2 hours ago, jefferson1 said:

na query ila undi

 

select *

from tablename

where abc = '12345' 

 

so where condition lo inko parameter add cheyali, which is created and it should get values from a date ignoring seconds.

1) Select * from table where abc =12345

and cast(substr(created,1,10) as date format ‘yyyy-mm-dd’) = ‘2020-02-26’