Hướng dẫn dùng dateparse trong PHP

Date and Time Operators#

Time Zone Conversion#

The AT TIME ZONE operator sets the time zone of a timestamp:

SELECT timestamp '2012-10-31 01:00 UTC';
2012-10-31 01:00:00.000 UTC

SELECT timestamp '2012-10-31 01:00 UTC' AT TIME ZONE 'America/Los_Angeles';
2012-10-30 18:00:00.000 America/Los_Angeles

Date and Time Functions#

Returns the current date as of the start of the query.

Returns the current time as of the start of the query.

Returns the current timestamp as of the start of the query.

Returns the current time zone in the format defined by IANA (e.g., America/Los_Angeles) or as fixed offset from UTC (e.g., +08:35)

This is an alias for CAST(x AS date).

Returns the last day of the month.

Parses the ISO 8601 formatted string into a timestamp with time zone.

Parses the ISO 8601 formatted string into a date.

Returns the UNIX timestamp unixtime as a timestamp.

Returns the UNIX timestamp unixtime as a timestamp with time zone using string for the time zone.

Returns the UNIX timestamp unixtime as a timestamp with time zone using hours and minutes for the time zone offset.

Returns the current time as of the start of the query.

Returns the current timestamp as of the start of the query.

This is an alias for current_timestamp.

Formats x as an ISO 8601 string. x can be date, timestamp, or timestamp with time zone.

Returns the day-to-second interval as milliseconds.

Returns timestamp as a UNIX timestamp.

Note

The following SQL-standard functions do not use parenthesis:

• current_date

• current_time

• current_timestamp

• localtime

• localtimestamp

Truncation Function#

The date_trunc function supports the following units:

The above examples use the timestamp 2001-08-22 03:04:05.321 as the input.

Returns x truncated to unit.

Interval Functions#

The functions in this section support the following interval units:

Adds an interval value of type unit to timestamp. Subtraction can be performed by using a negative value.

Returns timestamp2 - timestamp1 expressed in terms of unit.

Duration Function#

The parse_duration function supports the following units:

Parses string of format value unit into an interval, where value is fractional number of unit values:

SELECT parse_duration('42.8ms'); -- 0 00:00:00.043
SELECT parse_duration('3.81 d'); -- 3 19:26:24.000
SELECT parse_duration('5m');     -- 0 00:05:00.000

MySQL Date Functions#

The functions in this section use a format string that is compatible with the MySQL date_parse and str_to_date functions. The following table, based on the MySQL manual, describes the format specifiers:

Timestamp is truncated to milliseconds.

When parsing, two-digit year format assumes range 1970 .. 2069, so “70” will result in year 1970 but “69” will produce 2069.

This specifier is not supported yet. Consider using day_of_week() (it uses 1-7 instead of 0-6).

This specifier does not support 0 as a month or day.

Warning

The following specifiers are not currently supported: %D %U %u %V %w %X

Formats timestamp as a string using format.

Parses string into a timestamp using format.

Java Date Functions#

The functions in this section use a format string that is compatible with JodaTime’s DateTimeFormat pattern format.

Formats timestamp as a string using format.

Parses string into a timestamp with time zone using format.