Date Functions

Question

Post reply

Date Functions

Viewing 15 posts - 16 through 30 (of 35 total)

You must be logged in to reply to this topic. Login to reply

SqlMel SSCrazy Points: 2901 More actions · Answer 1

Good one. I'm glad we finally have this function.

I'm surprised it took so long!

---------------
Mel. 😎

sestell1 SSChampion Points: 10230 More actions · Answer 2

Toreador (10/24/2013)
For me, a better answer is to subtract one from the first day of the next month, as this method will allow the same code to be run on other versions of SQLServer. The EOMONTH function is of no use if you are writing a system that has to run on SQL2008 as well.

I agree. this method has been used for years, and has the added advantage of being slightly more portable. I'd say that makes it an excellent method as well.

tabinsc SSCommitted Points: 1812 More actions · Answer 3

sestell1 (10/24/2013)
Toreador (10/24/2013)
For me, a better answer is to subtract one from the first day of the next month, as this method will allow the same code to be run on other versions of SQLServer. The EOMONTH function is of no use if you are writing a system that has to run on SQL2008 as well.
I agree. this method has been used for years, and has the added advantage of being slightly more portable. I'd say that makes it an excellent method as well.

That's how I've always coded it, in T-SQL and even in Perl and Informix in my younger coding days.

Tony
------------------------------------
Are you suggesting coconuts migrate?

Dana Medley SSCertifiable Points: 6764 More actions · Answer 4

Toreador (10/24/2013)
For me, a better answer is to subtract one from the first day of the next month, as this method will allow the same code to be run on other versions of SQLServer. The EOMONTH function is of no use if you are writing a system that has to run on SQL2008 as well.

+1 for Toreador; however, it is good to see questions about new features so I can learn about them.

Everything is awesome!

OCTom SSChampion Points: 11785 More actions · Answer 5

I think either asking a coworker or looking at a physical paper calendar are both excellent! 😉

OCTom SSChampion Points: 11785 More actions · Answer 6

Toreador (10/24/2013)
For me, a better answer is to subtract one from the first day of the next month, as this method will allow the same code to be run on other versions of SQLServer. The EOMONTH function is of no use if you are writing a system that has to run on SQL2008 as well.

Having to write code for multiple versions is what holds me back from using the latest and greatest. I still have a system that is on SQL server 2005 for gosh sakes.

tabinsc SSCommitted Points: 1812 More actions · Answer 7

OCTom (10/24/2013)
Toreador (10/24/2013)
For me, a better answer is to subtract one from the first day of the next month, as this method will allow the same code to be run on other versions of SQLServer. The EOMONTH function is of no use if you are writing a system that has to run on SQL2008 as well.
Having to write code for multiple versions is what holds me back from using the latest and greatest. I still have a system that is on SQL server 2005 for gosh sakes.

Same here. We have 2008 locally and 2005 remotely. If not for the 2005 servers, I would be using MERGE instead of INSERT and UPDATE a lot more often.

Tony
------------------------------------
Are you suggesting coconuts migrate?

brozycki SSC Veteran Points: 255 More actions · Answer 8

brozycki

SSC Veteran

Points: 255

October 24, 2013 at 8:14 am

#1661299

Thank you! I learned a new helpful command today.

Miles Neale SSChampion Points: 13147 More actions · Answer 9

Thanks, we have needed this for some time. Glad to have it and the point!

Not all gray hairs are Dinosaurs!

doug.davidson SSCommitted Points: 1662 More actions · Answer 10

Good to know of the function exists but I still find it more useful to subtract, as this function only returns date; not date and time. I program in a datetime world.

Richard Warr SSCertifiable Points: 6966 More actions · Answer 11

doug.davidson (10/24/2013)
Good to know of the function exists but I still find it more useful to subtract, as this function only returns date; not date and time. I program in a datetime world.

So what time is it on the last day of the month? It's only worth the extra five bytes (DATETIME vs DATE) to store a time if it's relevant.

Thomas Abraham SSChampion Points: 10761 More actions · Answer 12

doug.davidson (10/24/2013)
Good to know of the function exists but I still find it more useful to subtract, as this function only returns date; not date and time. I program in a datetime world.

Same here. Need to know that last clock tick of the month sometimes too. Or write '<' earliest timestamp of next month.

[font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
Connect to me on LinkedIn

Marcia J SSCertifiable Points: 5649 More actions · Answer 13

I have to admit I was really tempted to answer "Ask a co-worker" even though I knew it would be incorrect. However, I decided to get the point instead.

Narud SSCrazy Points: 2837 More actions · Answer 14

One of every 100 SSC members believe that can "Create an array with the last day of every month", even when arrays is a feature not implemented in SQL Server yet. 😀

Revenant SSC-Forever Points: 42467 More actions · Answer 15

Revenant

SSC-Forever

Points: 42467

October 24, 2013 at 12:24 pm

#1661421

Easy, easy -- thanks, John!