string sqlDate( string $dateFormat, optional string $dateColumn )
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.
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.
|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|
|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|
|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)|
Day of week code (
w) is not consistently implemented across DB drivers, as the library relies on database-specific functions, e.g.
- MySQL: 0 (Sunday) to 6 (Saturday)
- MSSQL: not implemented
- Oracle: 1 to 7 (which day is 1 depends on NLS_TERRITORY setting)
- PostgreSQL: 1 (Sunday) to 7 (Saturday)
For a portable result, see the dow() method.
/* * 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.txt · Last modified: 2016/04/22 03:08 by mnewnham