rodchar
3/28/2007 6:14:00 PM
thank you.
"Alejandro Mesa" wrote:
> rodchar,
>
> See function "convert" in BOL.
>
> select convert(char(10), getdate(), 101)
> go
>
>
> AMB
>
>
> "rodchar" wrote:
>
> > hey all,
> > i'm trying to build this query that shows a date. is there a way to show
> > just the date and not the time?
> >
> > thanks,
> > rodchar