SQL Server 2000 - omitting the Time out of the Date

system · December 5, 2002, 3:26pm

Hi! Does anyone know how I would strip out the time from a date object in a SQL Server universe? I can datepart and get a MM/DD/YYYY object as a character, but it will not sort in ascending or descending order correctly. How do I do it?

Thanks!

Sarah Wentworth
Maine

swentworth (BOB member since 2002-11-19)

system · December 5, 2002, 4:16pm

Why donot you apply format on the data object to siplay as mm/dd/yyyy, donot need any function for this.

Reema

reemagupta (BOB member since 2002-09-18)

system · December 5, 2002, 5:20pm

Ok… if you want the outout as Date then do this
Convert(smalldatetime,convert(char(8),datecolumn,112))

and then do the formatting in the report if required as Reema suggested.

dcdas (BOB member since 2002-06-17)

system · December 5, 2002, 5:51pm

This formatting can be done at the universe level as well.

Reema

reemagupta (BOB member since 2002-09-18)