/**
* Converts a timestamp "ts" to a string that the database can understand.
*
* @param ts a timestamp in Unix date time format.
*
* @return timestamp string in database timestamp format
*/
function DBTimeStamp($ts)
{
if (empty($ts) && $ts !== 0) {
return 'null';
}
if (is_string($ts) && !is_numeric($ts)) {
if ($this->isoDates) {
return "'{$ts}'";
} else {
$ts = ADOConnection::UnixTimeStamp($ts);
}
}
return adodb_date($this->fmtTimeStamp, $ts);
}
/**
* @param $v is a timestamp string in YYYY-MM-DD HH-NN-SS format
*
* @return date in unix timestamp format, or 0 if before TIMESTAMP_FIRST_YEAR, or false if invalid date format
*/
function UnixTimeStamp($v)
{
return ADOConnection::UnixTimeStamp($v);
}
/**
* Converts a timestamp "ts" to a string that the database can understand.
*
* @param ts a timestamp in Unix date time format.
*
* @return timestamp string in database timestamp format
*/
function DBTimeStamp($ts)
{
if (empty($ts) && $ts !== 0) {
return 'null';
}
# strlen(14) allows YYYYMMDDHHMMSS format
if (!is_string($ts) || is_numeric($ts) && strlen($ts) < 14) {
return adodb_date($this->fmtTimeStamp, $ts);
}
if ($ts === 'null') {
return $ts;
}
if ($this->isoDates && strlen($ts) !== 14) {
return "'{$ts}'";
}
$ts = ADOConnection::UnixTimeStamp($ts);
return adodb_date($this->fmtTimeStamp, $ts);
}
