v5:reference:connection:sqldate
This is an old revision of the document!
sqlDate
See Also
Syntax
string sqlDate( string $dateFormat, optional string $dateColumn )
Description
When the function sqlDate()
is passed a string based on SQL date/time formats, it returns a database-independent date string, either using the system date, or if passed a string containing a datetime column in a table, a string derived from that column.
Supported Formats
The following column formats are supported across all databases. Other formats may be supported by certain databases but you should check them for portability. The codes used are based loosely on date formatting for Oracle databases.
Dates
Code | Description |
---|---|
Y,y | 4 Digit Year |
M | Month of year as a 3 character abbreviation (Jan,Feb etc…) |
m | Month of year as a 2 digit number 01-12 |
D,d | Day of month as a 2 digit number 01-31 |
Times
Code | Description |
---|---|
H | Hour of day in 24 Hour clock format 00-24 |
h | Hour of day in 12 Hour clock format 00-12 |
i | Minute of hour 00-59 |
A,a | AM/PM , use with h hour format |
Other Periods
Code | Description |
---|---|
Q,q | Yearly Quarter |
w | Day of week as 1 digit number |
W | Week of the year as a number (1-52) |
l | Day of week as full word (Monday, Tuesday, etc) |
Usage
/* * Assumes connection to oracle database */ $dateString = $db->sqlDate('Y-m-d') /* * Returns: TO_CHAR(SYSDATE,'YYYY-MM-DD'); */ $dateString = $db->sqlDate('m/d/y','trousers.purchase_date'); /* * Returns: TO_CHAR(trousers.purchase_date,'MM/DD/YYYY') */
v5/reference/connection/sqldate.1460508205.txt.gz · Last modified: 2017/04/21 11:32 (external edit)