Date Functions

Question

Post reply

Date Functions

John Hanrahan

Hall of Fame

Points: 3825
More actions
October 23, 2013 at 11:39 pm

#395720

Comments posted to this topic are about the item Date Functions
October 24, 2013 at 2:56 am

This was removed by the editor as SPAM

Viewing 15 posts - 1 through 15 (of 35 total)

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

Ford Fairlane SSCertifiable Points: 7664 More actions · Answer 1

Nice question - thanks

Hope this helps...

Ford Fairlane
Rock and Roll Detective

Ken SSCoach Points: 17191 More actions · Answer 2

Nice, easy one. I'm surprised this function hadn't come up in a question before now.

PRAMANA.DBA SSCertifiable Points: 5507 More actions · Answer 3

PRAMANA.DBA

SSCertifiable

Points: 5507

October 24, 2013 at 12:37 am

#1661146

Ford Fairlane (10/23/2013)
Nice question - thanks

sqlnaive SSCoach Points: 17437 More actions · Answer 4

Great QOTD. Why ? because i've yet to work on SQL 2012 and these sorts of questions help me getting familiar with new useful functionalities. Keep it up John. 🙂

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 5

I spotted at least 3 correct answers 😀

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Carlo Romagnano SSC-Insane Points: 22680 More actions · Answer 6

Till now "Ask a co-worker?" is 0%.

I am really surprised!

😛

sqlnaive SSCoach Points: 17437 More actions · Answer 7

sqlnaive

SSCoach

Points: 17437

October 24, 2013 at 1:43 am

#1661160

Good one Koen and Carlo... 🙂

paul s-306273 SSChampion Points: 10730 More actions · Answer 8

paul s-306273

SSChampion

Points: 10730

October 24, 2013 at 2:00 am

#1661163

Nice built-in function.

call.copse SSCoach Points: 18064 More actions · Answer 9

Didn't know this was in SQL, had only seen it in Excel, may be useful (we might upgrade to 2012 in 2021 or so!). I've always used 'Take the first day of next month and subtract a day' before.

Bangla Hall of Fame Points: 3137 More actions · Answer 10

The option "Ask a co-worker?" was excellent....:-)

Nice question....

Anipaul SSC-Insane Points: 24681 More actions · Answer 11

Anipaul

SSC-Insane

Points: 24681

October 24, 2013 at 4:42 am

#1661208

Nice one...

Richard Warr SSCertifiable Points: 6967 More actions · Answer 12

I was hunting for the option which said

Recite the rhyme:
30 days hath September,
April, June and November,
All the rest have 31,
Excepting February alone.
Which has but 28 days clear
And 29 in each leap year
to yourself

but then decided that particular choice was common across all releases of SQL Server.

So I went with the 2012-specific one.

Toreador SSChampion Points: 11368 More actions · Answer 13

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.