Why is dates so difficult?
-
DECLARE @Month VARCHAR(2), @Year VARCHAR(4)
IF (month(GETDATE())) = 1
BEGIN
Set @Month = MONTH(DateAdd(month, -1, GETDATE()));
Set @Year = YEAR(DateAdd(month, -1, GETDATE()));
END
ELSE
BEGIN
Set @Month = MONTH(GETDATE()) -1
Set @Year = YEAR(GETDATE())
ENDI just shook my head... It could have been done as easily as:
DECLARE @Month VARCHAR(2), @Year VARCHAR(4)
Set @Month = MONTH(DateAdd(month, -1, GETDATE()));
Set @Year = YEAR(DateAdd(month, -1, GETDATE())); -
DECLARE @Month VARCHAR(2), @Year VARCHAR(4)
IF (month(GETDATE())) = 1
BEGIN
Set @Month = MONTH(DateAdd(month, -1, GETDATE()));
Set @Year = YEAR(DateAdd(month, -1, GETDATE()));
END
ELSE
BEGIN
Set @Month = MONTH(GETDATE()) -1
Set @Year = YEAR(GETDATE())
ENDI just shook my head... It could have been done as easily as:
DECLARE @Month VARCHAR(2), @Year VARCHAR(4)
Set @Month = MONTH(DateAdd(month, -1, GETDATE()));
Set @Year = YEAR(DateAdd(month, -1, GETDATE())); -
DECLARE @Month VARCHAR(2), @Year VARCHAR(4)
IF (month(GETDATE())) = 1
BEGIN
Set @Month = MONTH(DateAdd(month, -1, GETDATE()));
Set @Year = YEAR(DateAdd(month, -1, GETDATE()));
END
ELSE
BEGIN
Set @Month = MONTH(GETDATE()) -1
Set @Year = YEAR(GETDATE())
ENDI just shook my head... It could have been done as easily as:
DECLARE @Month VARCHAR(2), @Year VARCHAR(4)
Set @Month = MONTH(DateAdd(month, -1, GETDATE()));
Set @Year = YEAR(DateAdd(month, -1, GETDATE()));A better question is, why are grammar so difficult?
-
A better question is, why are grammar so difficult?
You mean, why is grammars for naturals language so difficults, right? ;P Well, one explanation could be that the speaker is not a native speaker. But I agree, I'm annoyed by bad grammar too.