Formatting dates like Sunday, 19th April

Question

Viewing 5 posts - 1 through 4 (of 4 total)

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

Tom257 SSChampion Points: 11543 More actions · Answer 1

Use string manipulation and the built-in date functions

e.g.

SELECT DATENAME(weekday,(GetDate())) + ', ' +

CONVERT(varchar, GETDATE(), 109)

SEE CONVERT in BOL for a full list of date conversion options.

sqlguru-1118922 Old Hand Points: 339 More actions · Answer 2

Formatting is a front-end/middle-tier responsibility, why are you doing it in a RDMS where it is slower?

Paul White SSC Guru Points: 150467 More actions · Answer 3

sqlguru (6/24/2009)
Formatting is a front-end/middle-tier responsibility, why are you doing it in a RDMS where it is slower?

Perhaps because he was told to?

Just sayin'.

😀

balars_2000 Right there with Babe Points: 717 More actions · Answer 4

Right there with Babe

Points: 717

June 24, 2009 at 7:52 pm

Thanks 🙂