In Oracle, CURRENT_TIMESTAMP, CURRENT_DATE, SYSTIMESTAMP and SYSDATE are the same. CURRENT_DATE and CURRENT_TIMESTAMP returns a date / timestamp (respectively) data type reflecting the current date and time on the client (both have a time component, the timestamp also has fractional seconds). How to calculate current date (month) minus one month in crystal report? NOW () is used to insert the current date and time in the MySQL table. All fields with datatypes DATETIME, DATE, TIME & TIMESTAMP work good with this function. YYYY-MM-DD HH:mm:SS Demonstration: Following code shows the usage of NOW () The concept of the current date/time is complicated. 1 - System.currentTimeMillis () gives the system time. While it is normal practice for the system clock to be set to (nominal) UTC, there will be a difference (a delta) between the local UTC clock and true UTC. For the new PHP programmer might confuse why there are lot of method for to get current date and time and which one to use in their project. 1. date method (PHP 4, PHP 5, PHP 7) This is the very common and very easiest way to get the date and time in php. Use new Date () to generate a new Date object containing the current date and time. Hi Andrew, the solution you told returns exact 30 days back from current date. I need first date of the previous month irrespective of any date in current month. These classes supplant the troublesome old legacy date-time classes such as java.util.Date, Calendar, & SimpleDateFormat. The Joda-Time project, now in maintenance mode, advises migration to the java.time classes. To learn more, see the Oracle Tutorial. And search Stack Overflow for many examples and explanations. Specification is JSR 310. PHP: date function to get month of the current date Ask Question Asked 15 years, 10 months ago Modified 6 years, 4 months ago I need to add the current date into a prepared statement of a JDBC call. I need to add the date in a format like yyyy/MM/dd. I've try with DateFormat dateFormat = new SimpleDateFormat( yyyy/MM/dd.