convert date in sql

Question

Post reply

convert date in sql

Viewing 5 posts - 16 through 19 (of 19 total)

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

Performance Guard (Shehap) Ten Centuries Points: 1297 More actions · Answer 1

Guys, please feel free to have a tour through different date time converstion per the link below :

http://www.sqlusa.com/bestpractices/datetimeconversion/

[font="Arial Black"]Performance Guard[/font]

[font="Courier New"]Just ask me to get 0 sec for all queries[/font]

Brandie Tarvin SSC Guru Points: 172918 More actions · Answer 2

Performace Guard (Shehap) (10/14/2011)

Guys, please feel free to have a tour through different date time converstion per the link below :

http://www.sqlusa.com/bestpractices/datetimeconversion/%5B/quote%5D

Wow. That website is completely unreadable and horribly designed. Don't go there. It also has overly flashy popup ads.

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Jeff Moden SSC Guru Points: 1000539 More actions · Answer 3

R.P.Rozema (10/14/2011)
The opening post seemed to ask for a string to datetime conversion. However as was clarified only recently, poster was actually looking for a conversion from datetime into a formatted character string. Which was then correctly answered by GSquared.

I have to admit, I totally missed that. Thanks for the heads up.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
"Change is inevitable... change for the better is not".

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)
Intro to Tally Tables and Functions

Jeff Moden SSC Guru Points: 1000539 More actions · Answer 4

Brandie Tarvin (10/14/2011)

Performace Guard (Shehap) (10/14/2011)
Guys, please feel free to have a tour through different date time converstion per the link below :
http://www.sqlusa.com/bestpractices/datetimeconversion/%5B/quote%5D
Wow. That website is completely unreadable and horribly designed. Don't go there. It also has overly flashy popup ads.

We must be looking at different sites... although it was a bit slow to load and is a "code only" "demonstration", the code does have some documentation and I only came across one "flash" instance. It does have a fairly large list of code examples although some of the examples really could use a bit more of an explanation.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
"Change is inevitable... change for the better is not".

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)
Intro to Tally Tables and Functions

Brandie Tarvin SSC Guru Points: 172918 More actions · Answer 5

Jeff Moden (10/14/2011)

Brandie Tarvin (10/14/2011)
Performace Guard (Shehap) (10/14/2011)
Guys, please feel free to have a tour through different date time converstion per the link below :
http://www.sqlusa.com/bestpractices/datetimeconversion/%5B/quote%5D
Wow. That website is completely unreadable and horribly designed. Don't go there. It also has overly flashy popup ads.
We must be looking at different sites...

My webpage renders it with a bunch of little grey lines going right through the middle of everything, including the words. My eyesight can't handle that kind of visual.

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.