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 |
|
veparala
Starting Member
30 Posts |
 Posted - 2010-04-21 : 16:13:12
|
| Hi I have a Date object with timestamp (ex: 01/01/2009 12:00:00 AM). I need to remove timestamp from the date object (like 01/01/2009).what is the function for this?. Anybody help me.ThanksVenkat |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
veparala
Starting Member
30 Posts |
Posted - 2010-04-21 : 16:19:30
|
| Hi Thanks for the reply. But i don't want convert date into varchar datatype. Still i need date object after triming timestamp. |
 |
|
|
vijayisonly
Master Smack Fu Yak Hacker
1836 Posts |
Posted - 2010-04-21 : 16:24:16
|
| Then its no longer a datetime field. The datetime fields will always have the time portion along with it. As Tara suggested, do your formatting in your front end. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Trim timestamp from the date object