How to Remove time from SYSDATE

Please subscribe on my YouTube Channel.


 Truncate TimeStamp from Sysdate.

TRUNC(SYSDATE) will remove Timestamp

TO_CHAR(SYSDATE,'YYYYMMDD') will format the required format
By -

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Limitations of Pushdown Optimization - PDO

Limitations of Pushdown optimization. Source and Target and Lookups must be in same database server for full Pushdown. Expressions w...