Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
niravg
Starting Member
17 Posts |
 Posted - 2005-01-12 : 11:23:57
|
| hi all:how do i get just the date part of datetime columnmy table has "aDate" column has value say "12/12/2005 12.00AM"..i want just date part "12/12/2005" in return how do i get it-nii |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2005-01-12 : 12:18:23
|
select convert(varchar(10), aDate, 101)from MyTableyou have to be carefull when using this in a where clause because by doing a convert you can't use indexes that exist on that column.Go with the flow & have fun! Else fight the flow  |
 |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
|
|
|
|
|
how to get just date part of datetime column