modify time in datetime

[tek2002]

i have a column named trandate that is of datatype datetime and i need to do a sum function - grouping with several columns inluding the trandate column.

my numbers are off because of the time portion in the
trandate column so i was wondering if there was a way
to convert the time portion to all zero's.

2003-01-21 08:29:14.000 --> 2003-01-21 00:00:00.000

is there a way to do this conversion? this would solve my problem when using the sum function.

thanks for your help.

 

[swampBoogie]

use convert e.g.

convert(varchar,trandate,103)

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ca-co_2f3o.asp

 

[tek2002]

Thanks Much - Works Great!

never used the style parameter before.

 

[rute67]

In the help menu do a search for 'cast and convert' and that is everything you need to convert a date to any style you want.

There are still other ways besides this and if they don't help you just reply to this post.