Type time_t. The time_t type is generally 32-bit or 64-bit integer type. Note: A leap second increases or decreases by one second in Coordinated Universal Time (UTC), so that it is close to the adjusted time. 4. The clock tick count (clock tick) starts timing from the process startup, so this is the relative time. Every second contains clocks_per_sec (a constant defined in time. H, usually 1000. The number of clock tick messages is represented by the Data Type clock_t. The clock_t type is gener
usually a 32-bit or 64-bit integer type. Note: is a leap second added in Coordinated Universal Time (UTC? Or reduce it by one second, so that it is close to the adjustments made during normal hours. 4. The clock tick count (clock tick) starts from the start of the process, so this is the relative time. Every second includes clocks_per_sec (a constant defined in time. H, usually 1000. The number of clock tick messages is represented by the Data Type clock_t. Clock_t is usually a 32-bit integer.
Reproduced in: http://blog.chinaunix.net/uid-25909722-id-2827364.html architecture and related functions representing "Time" in Linux 2011-09-13 17:01:13Category: C/In the Linux system, there are many structures representing the concept of "time", and there are a lot of related time-processing functions, which gives people a very confusing feeling. Cause when we really want to use these structures and functions, we do not know exactly which structure and which functions to use. It is necessary t
to lock other rows of data in the same tables through the DML statement or the lock command.shared Lock (Share, abbreviation S lock)Add the S lock by using the lock table in share mode command. In this lockdown mode, no user is allowed to update the table. But allow other users to issue a select ... from the FOR UPDATE command to add RS locks to the table.Exclusive Lock (Exclusive, abbreviation x Lock)The x lock is added via the lock table in exclusive mode command. In this lockdown mode, other
Note: Only for learning Exchange, reprint please specify the source
Calendar Time: The number of seconds from one point of time (usually January 1, 1970 0:0 0 seconds) to the time_t data type.
GMT (Greenwich Mean time GMT): Standard period provided by the Royal Greenwich Observatory.
local time: The time calculated based on the GMT and local timezone.
TM Structure Body:
The TM structure body (time Struc
the date and time of each other.time_t This type is used to store the number of seconds from 1970 to now , to be more precise, you can use structural struct timeval, which is precise to subtle.struct Timeval{Long tv_sec; /* sec */Long tv_usec; /* microseconds */};and the direct storage date is a structure:struct TM{int tm_sec; /* seconds, normal range 0-59, but allowed to 61*/int tm_min; /* min, 0-59*/int tm_hour; /* hours, 0-23*/int tm_mday; /* Day,
MASICONG @ orcl> select sid from v $ mystat where rownum = 1;
SID
----------
35
MASICONG @ orcl> select sid from v $ mystat where rownum = 1;
SID
----------
1
1. Simulate the blocking example caused by insert, update, and delete, describe the corresponding information in v $ lock, and give an SQL demonstration.
MASICONG @ orcl> create table test (id varchar (2) primary key );
Table created.
INsert Blocking
MASICONG @ orcl> insert into test values (10 );
1 row created.
MASICONG @ orcl> insert int
There are several modes of locking in Oracle:0:none1:null Empty2:row-s line Sharing (RS): Shared table locks, Sub share3:row-x Line Exclusive (RX): For row modifications, sub Exclusive4:share shared Lock (S): Prevents other DML operations, Share5:s/row-x shared Row Exclusive (SRX): Block other transaction operations, Share/sub exclusive6:exclusive Exclusive (X): Independent access use, exclusive
The types provided by 1.oracle can be queried according to the type in v$lock_type, and we usually c
millisecond.
2. Data structures related to date and time
The TM structure can be used to obtain the date and time in standard C + +, and the TM structure is defined in Time.h as follows:
#ifndef _tm_definedstruct TM {int tm_sec; /* SEC – The value range is [0,59] * *int tm_min; /* Divide-take value range is [0,59] * *int tm_hour; /* Time-value range is [0,23] *
returns the number of seconds, Failure returns ((time_t)-1) value, and the reason for the error is in errno.
Code Description:
#include
#include
#include
#include
int main (int argc, char** argv)
{
int seconds = time (NULL);
printf ("%d\n", seconds);
return 0;
}
Execution results:
[Root@vm_174_171_centos unixtime]# g++-g-o unixtime_time unixtime_time.cpp
[Root@vm_174_171_centos unixtime]#./unixtime_time
1445008165
gmtime (get current time and date)
Function Description:
First, the Linux common time correlation function-asctime,ctime,getttimeofday,gmtime,localtime,mktime,settimeofday,timeAsctime: Converting dates to stringsCTime: Converts a number of seconds into a stringGettimeofday: Gets the time and date based on the given number of seconds subtracted from January 1, 1970Gmtime: Gets the time and date based on the given number of seconds subtracted from January 1, 1970LocalTime: Gets the time and date of the local time zone according to the given number of se
Date and Time
Asctime
Ctime
Gettimeofday
Gmtime
Localtime
Mktime
Settimeofday
Time
Asctime (represents the time and date in string format)
Related functions
Time, ctime, gmtime, localtime
Header file
# Include
Define functions
Char * asctime (const struct tm * timeptr );
Function Description
Asctime () converts the information in the tm structure referred to by the timeptr parameter to the time and date re
How to obtain system time in C ++
// Solution-advantage: only the C standard library is used; disadvantage: only seconds are allowed# Include # Include Int main (void){Time_t t = time (0 );Char TMP [64];Strftime (TMP, sizeof (TMP), "% Y/% m/% d % x % A % j day % Z this year", localtime ( T ));Puts (TMP );Return 0;}Size_t strftime (char * strdest, size_t maxsize, const char * format, const struct TM * timeptr );Generate a string based on the format str
precise timing in microseconds
Long Long l1,l2,l3;
Timeval TV1;
Take a Time
Gettimeofday (tv,null);
L1 = tv.tv_sec*1000*1000 + tv.tv_usec;
Execute some code, such as algorithm 1 ...
Second time taken
Gettimeofday (tv,null);
L2 = tv.tv_sec*1000*1000+tv.tv_usec;
Execute some code, such as algorithm 2 ...
Gettimeofday (tv,null);
L3 = tv.tv_sec*1000*1000+tv.tv_usec;
printf ("%lld%lld/n", L2-L1, L3-L2);
You can see the execution time of two algorithms in microseconds (one out of 10,000 seconds
synchronize.If you do not need a very precise time, and as long as the exact seconds, you can use another time functiontime_t time (time_t* timer);The function returns a UTC timestamp and sets the timestamp value for the timer if the timer parameter is passed in.However, the above two functions get the UTC timestamp, what if the time of the current time zone needs to be displayed in the game?With LocalTime or localtime_r, the effect is the same, just get the result parameter position is differe
Reprint Please specify Source: http://blog.csdn.net/luotuo44/article/details/39374759This article mainly deals with Linux time types, time functions, and sleep functions provided by Linux.the time type and the corresponding function:time_t:The most unfamiliar time type is probably the time_t type. It appears in the standard library of the C language. However, ISO C does not specify what type, range, and precision the time_t is, but is generally implemented as a signed integer in POSIX.The unit o
Http://net.pku.edu.cn/~yhf/linux_c/function/04.html
Asctime (the time and date are represented in string format)
Related functions
Time,ctime,gmtime,localtime
Table header File
#include
Defining functions
char * asctime (const struct TM * timeptr);
Function description
Asctime () Converts the information in the
Related functions: time, ctime, gmtime, localtime
// Certificate //--------------------------------------------------------------------------------------------------------------------------------------------------------//
Asctime (represents the time and date in string format)
# Include
Define functions
Char * asctime (const struct TM * timeptr );
Function Description
Asctime () converts the information in the TM
//-------------------------------------------------------------//
Asctime (represents the time and date in string format)
# Include Define functions
Char * asctime (const struct tm * timeptr );
Function Description
Asctime () converts the information in the tm structure referred to by the timeptr parameter to the time and date representation method used in the real world, and then returns the result in str
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.