Click the Start a free trial link to start a 15-day SaaS trial of our product and join our community as a trial user. If you are an existing customer do not start a free trial.
AppDynamics customers and established members should click the sign in button to authenticate.
03-24-2022 07:41 AM - last edited on 03-24-2022 09:09 AM by Ryan.Paredez
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"
User | Count |
---|---|
6 | |
1 | |
1 | |
1 |
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form