The current date is 2018/08/12.1. Get the number of days in the current month:Select To_number (To_char (Last_day (sysdate), ' DD ')) from dual2. Get the full date 30 days before the current date.Select trunc (sysdate-+)+ as from by RowNum ;The
Directory
I. Common commands for system backup and recovery1. fbackup/frecover2. Tar3. Sam4. copyutil5. make_recovery
Ii. methods and strategies for system backup and recovery1. system backup policy2. System Recovery Policy
1. Common commands for
1) Common fbackup Method 1:
[1] accessing a single user:
# Init-S or shutdown 0
[2] Full System Backup
# Fbackup-F/dev/RMT/0 m-0iv/-I/tmp/sysbk. Index
-F: Device File Name (such as DDS tape driver)
-I: directory to be included-E: excluded
With member [measures]. [full date] As 'now ()'-- The second calculated Member is the day part of the first calculated Member.Member [measures]. [What day] As 'day ([full date])'-- The third calculated Member is the month part of the first
Learning GoalsMastering the use of the date classyou can use the Calendar class to get a full dateMastering Date-formatted operationsformat conversion operation for dates that can be used with SimpleDateFormatto write a date-Acquired action
This is often used to format strings of dates and numbers, so we sorted out some of the help items here.
The following table describes the standard format specifiers used to format datetime objects.Format descriptionD short date mode D. Long date
Concept | advanced
Java Advanced Date Concepts
If your Java program displays time and date to users in different time zones or different countries, you need to understand some of the more advanced aspects of the Java date
Examples of C # String.Format
STRINGSTR1 =string. Format ("{0:n1}", 56789); //result:56,789.0
STRINGSTR2 =string. Format ("{0:n2}", 56789); //result:56,789.00
STRINGSTR3 =string. Format ("{0:n3
Data operation date and time
Date and time functions are useful for building a site. The owner of the site is often interested in when the data in a table is updated. With date and time functions, you can track changes in a table at the millisecond
C
Currency
2.5.ToString("C")
¥2.50
D
Decimal number
ToString("D5")
00025
E
Scientific type
25000.ToString("E")
2.500000E+005
F
Fixed point
ToString("F2")
DateTime.ToString (String, IFormatProvider)parameter format verbose usage :
format character
Association properties/Description
d
Shortdat Epattern
D
longdatepattern
The Char class is the character type provided by C #, which is the string type provided by C #.Character:The Char class represents a Unicode character in C #.The Char class defines only one Unicode character.The common methods and descriptions of
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.