DATEADD functionDescription: Returns the date on which the specified time interval has been added.Syntax DateAdd (interval, number, date)Interval: Must be selected. A string expression that represents the time interval to add. See the Settings
Use the function date () to implement the displayed in the format: year-month-day hours: minutes: secRelated Time parameters:A-"AM" or "PM"A-"AM" or "PM"D-A few days, two digits, if less than two digits before the 0; such as: "01" to "31"D-Days of
first, number numbers
106:one million
109:one billion (orone thousand million)
1012:one trillion (orone million)
1015:onequadrillion (or one thousand million)
1018:one quintillion (or one million million)
123,456,789:one hundred and twenty
--(Take the system time as an example, the actual situation can be replaced)1 Read system time –sysdateSelect sysdate from dual;2 Read time information (year, month, day, hour, minute, second)Select To_char (sysdate, ' Yyyy-mm-dd hh24:mi:ss ') as
First, Date, SimpleDateFormat, calendar difference and useIi.Overview of dates in Java Date in Java is a very complex piece of content, for a date in a different language country environment, date internationalization, conversion between date and
Overview of dates in JavaDate in Java is a very complex content, for a date in different language country environment, date internationalization, date and time conversion, date of addition and subtraction operation, date display format is very
Now () gets the current system Date and Time. asp output can be written as follows:
Year (now () gets the year, ASP output:
Month (now () gets the current month, ASP output:
When day (now () is obtained, ASP outputs:
Minute (now () gets the
Date functionDescription: returns the current system date.Syntax: Date Dateadd FunctionDescription: return the date of the specified interval that has been added.Syntax: dateadd (interval, number, date)Interval: required. String expression,
In this article, readers will learn some basic design methods and the use of time objects, as well as some of the basic syntax. This alarm clock has the function of displaying time, date, week, hour, clock alarm, etc.
Effect Preview Chart:
Click
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.