EOMONTH

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by bitbucket » EOMONTH - 1

26 posts, Page 1 of 3

1 2 3 »»»

EOMONTH - 1

Rate Topic

Display Mode

Topic Options

Author

Message

bitbucket-25253

Posted Sunday, January 20, 2013 5:48 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 3:04 PM
Points: 5,101, Visits: 20,200

Comments posted to this topic are about the item EOMONTH - 1

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read
Before posting a performance problem please read

Post #1409270

SQLRNNR

Posted Sunday, January 20, 2013 12:55 PM

SSCoach

Group: General Forum Members
Last Login: Today @ 1:07 PM
Points: 18,733, Visits: 12,332

Thanks Ron

Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server 2008

SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp

Post #1409300

Lokesh Vij

Posted Sunday, January 20, 2013 9:15 PM

Ten Centuries

Group: General Forum Members
Last Login: Today @ 10:37 PM
Points: 1,172, Visits: 1,247

Thanks Ron for another one on SS 2012!

~ Lokesh Vij

Guidelines for quicker answers on T-SQL question
Guidelines for answers on Performance questions

Link to my Blog Post --> www.SQLPathy.com

Follow me @Twitter

Post #1409343

demonfox

Posted Sunday, January 20, 2013 10:03 PM

Ten Centuries

Group: General Forum Members
Last Login: 2 days ago @ 6:46 PM
Points: 1,074, Visits: 1,076

Thanks Ron .

~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one Ermm

Post #1409346

Koen Verbeeck

Posted Monday, January 21, 2013 12:12 AM

SSCrazy Eights

Group: General Forum Members
Last Login: Today @ 9:06 AM
Points: 9,367, Visits: 6,465

Easy one, thanks Smile

I selected the answers one could expect, because it would be pretty sad if they messed up a brand new function BigGrin

How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence

Post #1409369

rals

Posted Monday, January 21, 2013 12:15 AM

SSCommitted

Group: General Forum Members
Last Login: Yesterday @ 1:13 AM
Points: 1,720, Visits: 746

Lokesh Vij (1/20/2013)

Thanks Ron for another one on SS 2012!

+1

^{Regards,
Rals.}

Post #1409370

Raghavendra Mudugal

Posted Monday, January 21, 2013 12:59 AM

SSC-Addicted

Group: General Forum Members
Last Login: Today @ 4:10 AM
Points: 444, Visits: 1,195

good one.

(.. i didn't know the existence of EOMONTH till now; and the functions in the SQL mainly turn to pink color font by default, by seeing the T-SQL code initially felt like is this a trick question? and literally did the BOL search and yes.... there you are... Smile

and understood that the IFCodes needs updating to the 2012 keywords... BigGrin

)

ww; Raghu
--
There are only 10 types of people in the world, those who understand binary, and those who don't.

Note: (as of now) only.. 1 and 4 applies (i am on my way...)

Post #1409385

Sean Pearce

Posted Monday, January 21, 2013 1:21 AM

Old Hand

Group: General Forum Members
Last Login: Today @ 9:49 AM
Points: 341, Visits: 1,308

This question is better suited for www.GeographyCentral.com.

How does knowing the last day of February in 2016 have anything to do with SQL Server? I had to check a calendar in order to answer this question, books online was no good here.

http://thesqlguy.blogspot.com/

Post #1409396

Stewart "Arturius" Campbell

Posted Monday, January 21, 2013 2:24 AM

Hall of Fame

Group: General Forum Members
Last Login: Today @ 3:48 AM
Points: 3,125, Visits: 4,311

Good qurstion, Ron,
Thanks

Sean Pearce (1/21/2013)

Point of note:
The EOMONTH function in Excel currently does not recognise leap years. Therefore, if this was an exact copy of the function as used in Excel, it would not work correctly.

____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”

Post #1409430

Sean Pearce

Posted Monday, January 21, 2013 2:49 AM

Old Hand

Group: General Forum Members
Last Login: Today @ 9:49 AM
Points: 341, Visits: 1,308

Stewart "Arturius" Campbell (1/21/2013)

Good qurstion, Ron,
Thanks

Sean Pearce (1/21/2013)

Point of note:
The EOMONTH function in Excel currently does not recognise leap years. Therefore, if this was an exact copy of the function as used in Excel, it would not work correctly.

Since when did SQL Server start copying Excel?

http://thesqlguy.blogspot.com/

Post #1409445

« Prev Topic | Next Topic »

26 posts, Page 1 of 3

1 2 3 »»»

Permissions