Date format in DB2 Query

How to pass date formats in DB2 query ?

Solution

SELECT * FROM  <YOUR_TABLE_NAME>  WHERE  <YOUR_DATE_ATTRIBUTE> = TO_DATE('01-04-2022','DD-MM-YYYY') ;

Without Date Format

SELECT * FROM  <YOUR_TABLE_NAME>  WHERE  <YOUR_DATE_ATTRIBUTE> = TO_DATE('2022-04-01') ;

More Questions