Oct 26, 2004 #1 rp1504 Programmer Oct 11, 2004 11 0 0 US How to truncate the time stamp from DATE in sql server I did try to use CONVERT function but did not work?
How to truncate the time stamp from DATE in sql server I did try to use CONVERT function but did not work?
Oct 26, 2004 Thread starter #2 rp1504 Programmer Oct 11, 2004 11 0 0 US It should return DATE only. Upvote 0 Downvote
Oct 27, 2004 #3 vongrunt Programmer Mar 8, 2004 4,863 0 0 HR So far there is no separated date type (Yukon will fix that). To remove time fraction, see thread183-921333. Upvote 0 Downvote
So far there is no separated date type (Yukon will fix that). To remove time fraction, see thread183-921333.
Dec 14, 2004 #4 JBaileys Technical User Jun 23, 2003 244 0 0 US You may want to check out the convert function... Example: select convert(varchar,DateColumn,101) from MyDateTest99 Additional info: http://www.sqljunkies.com/HowTo/6676BEAE-1967-402D-9578-9A1C7FD826E5.scuk Upvote 0 Downvote
You may want to check out the convert function... Example: select convert(varchar,DateColumn,101) from MyDateTest99 Additional info: http://www.sqljunkies.com/HowTo/6676BEAE-1967-402D-9578-9A1C7FD826E5.scuk