Also, in QA - if you select "use regional settings when displaying currency, number, dates, and times"

under the "connections" tab in "tools" - "options" you should see the difference in...

Sounds of applause!!!

Now do you have anything for the required formatting other than concatenation ?!?!

<pre class="code"

SELECT convert(varchar, DATEADD(s, epochCol,'19700101'), 103) + ' '

...

Michelle - until your request is "heard", you could..

1) Bookmark the link

2) unsubscribe from all posts but the ones that really interest you.

as soon as I read JT's post it triggered memories of the other one long ago where you met a gruesome death....and I believe it was Brian (kelley) who set...

Glad you asked Dale - if Jamie hadn't said "don't shout geek" (that threw me off even further...) I'd have hazarded any number of guesses - the top three being...

1)...

Nope - since there're only 2 responses - okay - I'll compromise & rephrase...yours is the better one since it avoids concatenation...

Very nice govinn - "I think govinn's approach is the best one." - since there's no concatenation involved.

Hey - the weekend bug's...

try converting it to datetime..."select convert(datetime, fldSmallDateTime)"

"best one" - from all these numerous posts that're vying with each other to provide the solution..?!?!

SELECT RIGHT(companyname, 3) AS lastThreeChars,companyname FROM Customers

another thing..."at the client site i'm having having to export all sql data tables to Microsoft Access (mdb) and to import them back into my sql server is becoming a...

1) Trotting the globe - haven't been able to do this seriously for a long time but I spend hours, days and weeks planning my next trip down to the...

Jeff - don't forget to tell Tom that he also managed to benefit from your expertise at a time when you were more relaxed than usual and not biting peoples'...

"I like having the entire database script as a reference."....couldn't agree more!

I have it scripted and stored in source safe...

Tom - this is an old post now - you'd be much better off starting a new thread with your questions - you'll get much wider readership that way since...