Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««123

EOMONTH - 1 Expand / Collapse
Author
Message
Posted Monday, January 21, 2013 12:05 PM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 7:38 AM
Points: 4,379, Visits: 3,391
Ron, as always I love your question. Please keep them comin'!
Post #1409667
Posted Monday, January 21, 2013 1:14 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 6:01 PM
Points: 5,563, Visits: 24,697
Revenant (1/21/2013)
Ron, as always I love your question. Please keep them comin'!


Thank you .. coming from one as knowledgable as you about sql ... it is an honor


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 #1409688
Posted Monday, January 21, 2013 10:04 PM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Thursday, June 5, 2014 8:36 AM
Points: 926, Visits: 556
Even though i got idea about the function from BOL, I don't want to sit and calculate what will be the last day of 2016 or last day of february 2016.

So I created an UDF to do the work of EOMONTH() and excuted the script to find the answer of QotD.

I thank Ron for introducing this new function to most of us..


--
Dineshbabu
Desire to learn new things..
Post #1409779
Posted Tuesday, January 22, 2013 4:16 AM


Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Thursday, June 12, 2014 4:19 AM
Points: 701, Visits: 1,145
Thank you for the question.
Post #1409917
Posted Tuesday, February 19, 2013 10:51 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, July 10, 2014 3:25 PM
Points: 2,133, Visits: 867
I still don't get why people when talking about Dates include a Time Component. Dates are Dates and Time is Time. We have had Date & Time Data Types for many years now but it seems SQL Server folk love their datetime and all of the Arcane knowledge required to use it.

Personally I'd like to see datetime deprecated so that we're left with Date, Time & DateTime2.

I'm interested to know who is still using datetime when all that they really want is Date.

End of Rant.
David
Post #1421928
Posted Friday, February 22, 2013 1:47 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 7:07 AM
Points: 1,144, Visits: 298
get 1 point without running the code

but last day of 2016 is pure chance !
Post #1422909
« Prev Topic | Next Topic »

Add to briefcase «««123

Permissions Expand / Collapse