SALT v2.0.0 » \salt\SqlDateFormat

Predefined SQL date store format

package	salt\dao

Methods

Check if a format is compatible with the DATETIME MySQL type

isFullDate(string $format) : boolean

Static

Parameters

$format

string

predefined format

Returns

booleanTRUE if the format is compatible with a full mysql date

Check if a format is RAW_TIMESTAMP

isRawTimestamp(string $format) : boolean

Static

Parameters

$format

string

predefined format

Returns

booleanTRUE if the format is stored as a timestamp

Convert a format (predefined or not) in real SQL format

resolve(string $format) : string

Static

Parameters

$format

string

Format identifier or SQL format

Returns

stringreal SQL format

Convert a format (predefined or not) in real PHP format

resolvePHP(string $format) : string

Static

Parameters

$format

string

Format identifier or PHP format

Returns

stringreal SQL format

Properties

PHP format list for all predefined date formats

$PHP_FORMAT : array<mixed,string>

Default

array(self::RAW_TIMESTAMP => 'U', self::TIMESTAMP => 'Y-m-d H:i:s', self::DATETIME => 'Y-m-d H:i:s', self::DATE => 'Y-m-d', self::SHORT_DATE => 'Ymd')

Static

format list for all predefined date formats

$SQL_FORMAT : array<mixed,string>

Default

array(self::RAW_TIMESTAMP => 'DO NOT USE IT', self::TIMESTAMP => '%Y-%m-%d %H:%i:%s', self::DATETIME => '%Y-%m-%d %H:%i:%s', self::DATE => '%Y-%m-%d', self::SHORT_DATE => '%Y%m%d')

Static

Constants

field is a DATE

DATE = 'DATE'

field is a DATETIME

DATETIME = 'DATETIME'

field is stored in an integer or text field, as a timestamp.

RAW_TIMESTAMP = 'timestamp'

field is stored in an integer or text field with format %Y%m%d

SHORT_DATE = 'SHORT_DATE'

field is a TIMESTAMP

TIMESTAMP = 'TIMESTAMP'