Fix for Joomla ‘JFolder::create: Could not create directory’ Error

Unlike other Errors, the fix for this error is pretty Simple. Follow the steps below to fix it.
#1 Goto your Hosting panel >> File Manager >> Select your Domain/Sub-Domain and then open the configuration.php file.
#2 Find var $log_path, it will contain the Directory path of your Old Server. Just replace the whole line with the code var $log_path = './logs';
#3 Find var $tmp_path, it will also have the Directory path of your Old Server. Replace the whole line with the code var $tmp_path = './tmp';

Convert DateTime to Month/Year(SQLServer)

Convert DateTime to Month/Year(SQLServer)

select convert(varchar(2),datepart(month,getdate())) + '/' +
convert(varchar(4),datepart(year,getdate())) 

DATE FORMATE OF MYSQL AND SQLSERVER

SQLSERVER

date>='mm-dd-yyyy' and date<='mm-dd-yyyy'

MYSQL

date>='yyyy-mm-dd' and date<='yyyy-mm-dd'