How to get Date from Timestamp in Redshift Database

TRUNC function can be used to extract date from the timestamp. sysdate returns current date with timestamp as shown below:

SELECT sysdate;

timestamp
-----------------------
2021-02-02 12:56:34.283756
SELECT trunc(sysdate);

trunc
---------
2021-02-02
See also  Arithmetic Functions in Redshift database