How to extract the values from table based on the current date. How to write the query? Select event_code from table name where date = sysdate What will be added in the place of sysdate? This query will run daily to fetch the records.
Select event_code from tablename where date=convert(varchar(10),getdate(),105)
GetDate() --- will give you the current date time
Convert function is used to convert the Date Time to Date
Using 105 code in the Convert function to convert it to DD-MM-YYYY Format
System Date
Select event_code from table name where date = sysdate
What will be added in the place of sysdate? This query will run daily to fetch the records.
Related Answered Questions
Related Open Questions