[#4817] - Default Expired Date Field on MSSQL is too old.
- Closed
- 21 Oct 2014
- Medium
- Build: master
- # 4817
Steps to reproduce the issue
add new content/module or any where that's have expired date field.
on MySQL normally we don't add date on expired date. but on MSSQL when we add new content
default expired date will be 1970.
Expected result
Actual result
System information
Setting Value
PHP Built On Windows NT EDKNETWORK 6.1 build 7601 (Windows Server 2008 R2 Enterprise Edition Service Pack 1) i586
Database Version 10.50.2500
Database Collation MSSQL UTF-8 (UCS2)
PHP Version 5.4.14
Web Server Microsoft-IIS/7.5
WebServer to PHP Interface cgi-fcgi
Joomla! Version Joomla! 3.3.6 Stable [ Ember ] 01-October-2014 02:00 GMT
Joomla! Platform Version Joomla Platform 13.1.0 Stable [ Curiosity ] 24-Apr-2013 00:00 GMT
User Agent Mozilla/5.0 (Macintosh; Intel Mac OS X 10.9; rv:32.0) Gecko/20100101 Firefox/32.0
Additional comments
Yes this related to the work you were doing on dates. The TIMESTAMP data type is used for values that contain both date and time parts. TIMESTAMP has a range of '1970-01-01 00:00:01' UTC to '2038-01-19 03:14:07' UTC. It has varying properties, depending on the MySQL version and the SQL mode the server is running in.
This comment was created with the J!Tracker Application at issues.joomla.org/joomla-cms/4817.
@Bakual yes. it's same issue. Just tested #3803
it fail on MSSQL.
This comment was created with the J!Tracker Application at issues.joomla.org/joomla-cms/4817.
| Title |
|
||||||
@Bakual Today, I just retest #3803 and it's success and solved this's issue.
@brianteeman Please close this issue.
This comment was created with the J!Tracker Application at issues.joomla.org/joomla-cms/4817.
zero-24
- | Status | New | ⇒ | Closed |
| Closed_Date | 0000-00-00 00:00:00 | ⇒ | 2014-10-21 12:59:04 |
| Labels |
Added:
?
|
||
@bakual is this related to the work you were doing on dates
This comment was created with the J!Tracker Application at issues.joomla.org/joomla-cms/4817.