DateTime Functions

Question

Post reply

DateTime Functions

Steve Jones - SSC Editor

SSC Guru

Points: 736524
More actions
April 4, 2012 at 8:17 pm

#100837

Comments posted to this topic are about the item DateTime Functions

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

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

baabhu SSCertifiable Points: 6205 More actions · Answer 1

baabhu

SSCertifiable

Points: 6205

April 4, 2012 at 8:26 pm

#1469273

Nice !!!. Good to learn knew stuff !!!!.

SQLRNNR SSC Guru Points: 281334 More actions · Answer 2

I like it - keep em coming.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 3

Lynn Pettis

SSC Guru

Points: 442467

April 4, 2012 at 9:41 pm

#1469293

Definately a good question.

Nakul Vachhrajani SSChampion Points: 10294 More actions · Answer 4

Nice question, Thank-you, Steve! Learnt something new.

Thanks & Regards,
Nakul Vachhrajani.
http://nakulvachhrajani.com

Follow me on
Twitter: @sqltwins

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

Great question, thanks. I never use this datatype though.

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: 22682 More actions · Answer 6

Carlo Romagnano

SSC-Insane

Points: 22682

April 5, 2012 at 2:37 am

#1469352

Good question!

Thanks.

😛

CoolCodeShare SSCrazy Points: 2584 More actions · Answer 7

CoolCodeShare

SSCrazy

Points: 2584

April 5, 2012 at 4:55 am

#1469398

Nice Question!

Thomas Abraham SSChampion Points: 10761 More actions · Answer 8

Thanks Steve! We currently code for locations in one time zone, so we don't use these types of things much. However, we recently became part of a global enterprise and will have to start doing so. Time zone considerations and collation considerations will finally become important to us, and not just as QOTD's.

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

Daniel Bowlin SSC-Dedicated Points: 34566 More actions · Answer 9

Had to read a bit to figure it out, learned something. Thanks.

OzYbOi d(-_-)b SSCarpal Tunnel Points: 4054 More actions · Answer 10

OzYbOi d(-_-)b

SSCarpal Tunnel

Points: 4054

April 5, 2012 at 8:24 am

#1469554

good question - cheers

yannick.dinger SSC Veteran Points: 206 More actions · Answer 11

yannick.dinger

SSC Veteran

Points: 206

April 5, 2012 at 8:37 am

#1469567

learn something new today 🙂

EL Jerry SSCertifiable Points: 7063 More actions · Answer 12

Good question, Steve. I like this kind of questions where I have to read and learn new things.

"El" Jerry.

"A watt of Ottawa" - Gerardo Galvan

To better understand your help request, please follow these best practices.[/url]

mtassin SSC-Insane Points: 23099 More actions · Answer 13

Thanks for an easy one.

I personally love this data type... it makes dealing with multi-time zone data a little bit easier.... datetime data still gives me more headaches than any other.

"Ok Ms. Smith we'll schedule a callback at 3pm your time in California on Friday"

Ok so she's in a portion of California that doens't follow DST, we're in Chicago and we do.

Is Friday in or out of DST? Do we know her correct TZ? What about when our east coast support team decides to handle this one?

*sigh*

Headaches I tell you... 🙂

--Mark Tassin
MCITP - SQL Server DBA
Proud member of the Anti-RBAR alliance.
For help with Performance click this link[/url]
For tips on how to post your problems[/url]

Steve Jones - SSC Editor SSC Guru Points: 736524 More actions · Answer 14

Glad you liked this one. It was one that taught me something when I wrote it.