February 2, 2011 at 6:04 am
Hi there,
Can you help with the followuing. I have looked at SQL Books Online and can't work out what they are telling me to do.
Basically I have the following datatype - SSFixTime which is a DATETIME FORMAT.
I am calling it in my SELECT statement as
SOJ.SSFixTime AS 'ServiceSchemeFixDateTime', which pulls me back a data as below -
2010-12-13 08:30:00.000
All I want to pull back is the DATE in the following format and pull back something like - 13-12-2010 or 13/12/2010.
Can you please assist
As always thank you
February 2, 2011 at 6:10 am
If this is a presentation issue, it should be taken care of by you presentation layer.
With regard to sqlserver, keep the original data type as long as possible.
As by your Q header, you should use the convert keyword to obtain what you want;
Can this server you ?
Select convert( char(10), yourdatecol, 103) have a look in books online.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
February 2, 2011 at 7:38 am
Thanks for this
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply