Oracle : Display Current Date

Share

Go to column properties then set initial value $date$ for user machine sysdate or use$dbdate$ for server machine sysdate.

If need sysdate with time then write $datetime$ or $dbdatetime$

*********************************************************************************************************************
Note : Please not do make backups before using these queries and also confirm them yourself or by aother means as
 well.
*********************************************************************************************************************
Share

Comments

comments

Leave a Reply