Convert 2003-01-08 00:00:00 into 08/01/2003

Question

Convert 2003-01-08 00:00:00 into 08/01/2003

jvElecenter

SSCarpal Tunnel

Points: 4502
More actions
December 1, 2004 at 1:22 am

#63575

I know it's an easy question but I don't find any solution.
My table contains this date : 2003-01-08 00:00:00
I'm polling it in excel with a parameter, but the users here are using dates like 08/01/2003
How can I resolve this ?
Thx from this newbie.

Jeff

JV

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

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

Frank Kalis SSC Guru Points: 111183 More actions · Answer 1

Couldn't you users just hit Strg+1 in Excel? This is merely a presentational issue. Once you've formatted the sheet, it should be okay.

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

Dave Bell-174911 SSC Journeyman Points: 84 More actions · Answer 2

select convert(varchar,cast('2003-01-08 00:00:00'as datetime),103)

There are 10 types of people in this world - those that understand binary and those that don't

silentnoise SSC Veteran Points: 292 More actions · Answer 3

Convert(Char(10),GetDate(),103)

You can replace the GetDate() function by any datetime fieldname.

Yoda-193403 SSC Eights! Points: 988 More actions · Answer 4

Confuse it not, data with presentation ! Different they are!

A true jedi will not let the presentation of the data confuse him with the value stored.

Stored data, no format at all does it possess. The physical world, requires a presentation it does. But true data lives within. Ignore what your eyes tell you -- trust in the true nature of what the table contains.

T-SQL, use it not for formatting! Excel, Access, Crystal -- those tools are designed for that purpose. A true SQL jedi will not interfere with presentation; you must work in harmony with the client applications.

To confuse formatting and presentation with data -- a quick path to the dark side, indeed!