cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

How to put a date and time condition in a ADQL statement

Tausif.Ahmad
Creator

How can I put the current date in the where clause? For example with the below query I want to fetch all IDOCs that has been created today. I have just hard coded today's date. What should I use to put the today's date condition?

 

SELECT CREDAT, DOCNUM, STATUS, MESTYP, TIMESTAMP FROM idocs_details WHERE MESTYP = "ZPSWDMGMT" AND CREDAT = "20220324" anD STATUS = "51"

0 REPLIES 0