Astronomy has a type of consecutive days of Confucianism (JD), which begins with the GMT noon of January 1, 4713 BC on 0th. There is also a simplified Confucianism Day (MJD): MJD = JD-2400000.5 MJD's 0th day started from GMT on November 17, 1858 AD.
Recently imported data in PostgreSQL, encountering time problems, combing the time in the database:1. Basic Concepts1.1 Date: That is the commonly said year, month, and day, the following is a list of valid date formats:
Example
Welcome to the Oracle community forum and interact with 2 million technical staff to enter 1rowcreated. SQLselect * fromtest_zone; TIMESTAMP_DTZONE_DTLOCAL_ZONE_DT Login --------------------------------------------------------------------------------
Unsolved. In the study
Solution:
Data Type problems:
Table 8-4. Character Type
Name
Description
Character varying (N), Varchar (N)
Variable Length with length restrictions
Character (N), Char (N)
Fixed Length, insufficient fill blank
Text
Variable
The data type specifies what type of data to store in the table field. When you create a table, you must use the data type for each column.There are three main types of data types in Potgresql. In addition, users can CREATE TYPE create their own
Julian Date DefinitionJulian Date: The valid date range is from January 1, 4713 BC to December 31, 9999. Julian Date is the number of days elapsed since 12 o'clock noon January 1, 4713.Using it Julian date allows us to calculate how many days
1. nsuserdefaults
I personally think the IOS method is a bit similarProperties. settings. Default in C #, Nsuserdefaults only supports: nsstring, nsnumber, nsdate, nsarray, nsdictionary.
There are multiple methods for creating a user ults, which is
Meaning of time strings in NSDateFormatter, nsdateformatter
A: AM/PM (morning/afternoon)
A: 0 ~ 86399999 (the second microsecond Of A day)
C/cc: 1 ~ 7 (the first day of the week, the day of the week is 1)
Ccc: Sun/Mon/Tue/Wed/Thu/Fri/Sat
NSDateFormatter date format, nsdateformatter
Statement of metadata:
G: AD
An example of the year:
Yy: two digits behind the year
Yyyy: indicates the complete year.
My life, my little drops.
#pragma mark.NSDate Creation (example class method only, instance method)Returns the current time (gmt,0 time Zone, GMT)+ (ID) date;Returns based on the current time and then secs seconds+ (ID)
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.