Copy Code code as follows:
/*
* Date Format 1.2.3
* (c) 2007-2009 Steven Levithan
* MIT License
*
* Includes Enhancements by Scott Trenda
* and Kris Kowal
*
* Accepts a date, a mask, or a date and a mask.
* Returns A formatted version
The syntax of plsql is different from that of tsql. For details, refer.
The syntax of plsql is different from that of tsql. For details, refer.
Mathematical functions
1. Absolute Value
S: select abs (-1) value
O: select abs (-1) value from dual
2.
CopyCode The Code is as follows :/*
* Date Format 1.2.3
* (C) 2007-2009 Steven levithan
* Mit license
*
* Includes enhancements by Scott trenda
* And Kris Kowal
*
* Accepts a date, a mask, or a date and a mask.
* Returns a formatted version of the
Date object formatting method. For more information, see.
The Code is as follows:
/** Date Format 1.2.3* (C) 2007-2009 Steven Levithan* MIT license** Includes enhancements by Scott Trenda* And Kris Kowal** Accepts a date, a mask, or a date and a
1.UNIX time StampPHPD processing data, especially when the time type data in the database is formatted, it is necessary to convert the time type data into the UNIX timestamp for processing. Different database systems for time-type data
cannot be
1.UNIX time StampPHPD processing of data, especially when the time type data in the database is formatted, it is necessary to convert the time type data into the UNIX timestamp processing. Data for time types in different database systems
cannot be
1.UNIX time StampPHPD processing of data, especially when the time type data in the database is formatted, it is necessary to convert the time type data into the UNIX timestamp processing. Data for time types in different database systems
cannot be
Date functionDate functions manipulate Date values (fields of date type), timestamp values (TIMESTAMP, TIMESTAMP with time ZONE, and TIMESTAMP with the fields of the local time ZONE type), and interval values (INTERVAL day to SECOND and INTERVAL
SQL Server Date and Time Processing set
When the convert date conversion format is 20 or 120, the resulting string does not contain milliseconds.For example, select convert (varchar (23), getdate (), 120 or 20)21:46:43
When the date conversion
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.