public function testConvertTimestampToDbFormatDateTimeAndBackToTimeStamp()
{
$time = time();
$timeZone = date_default_timezone_get();
date_default_timezone_set('GMT');
$gmtDbFormatDateTime = Yii::app()->dateFormatter->format(DatabaseCompatibilityUtil::getDateTimeFormat(), $time);
date_default_timezone_set('America/New_York');
$dbFormatDateTime = DateTimeUtil::convertTimestampToDbFormatDateTime($time);
$timeStamp = DateTimeUtil::convertDbFormatDateTimeToTimestamp($dbFormatDateTime);
$this->assertEquals($gmtDbFormatDateTime, $dbFormatDateTime);
$this->assertEquals($time, $timeStamp);
date_default_timezone_set($timeZone);
}
public function testGetDateTimeFormat()
{
$this->assertEquals('yyyy-MM-dd HH:mm:ss', DatabaseCompatibilityUtil::getDateTimeFormat());
}
public function testDateTimeValidation()
{
$this->assertNotNull(CDateTimeParser::parse('2009-11-11 21:18:09', DatabaseCompatibilityUtil::getDateTimeFormat()));
$this->assertEmpty(CDateTimeParser::parse('ascascasc', DatabaseCompatibilityUtil::getDateTimeFormat()));
$this->assertEmpty(CDateTimeParser::parse(null, DatabaseCompatibilityUtil::getDateTimeFormat()));
}
public static function convertTimestampToDbFormatDateTime($timestamp)
{
assert('is_int($timestamp)');
$timeZone = date_default_timezone_get();
date_default_timezone_set('GMT');
$result = Yii::app()->dateFormatter->format(DatabaseCompatibilityUtil::getDateTimeFormat(), $timestamp);
date_default_timezone_set($timeZone);
return $result;
}
