Re: Date format conversion

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 4 Jan 2001 21:00:17 +0100
Message-ID: <932nip$8clr1$1@ID-62141.news.dfncis.de>

Best way to do this is to use
trunc(date_column)

Regards,

Sybrand Bakker, Oracle DBA

<clewis_at_epylon.com> wrote in message news:932jdv$r43$1_at_nnrp1.deja.com...
> I'm currently selecting and grouping by a datetime field, which of
> course is listing each row individually.
>
> If I want to group by just the day, what is the syntax for formatting
> the datetime field to return the date without the time? And isn't this
> done in the select statement?
>
> Thanks!
>
>
>
> Sent via Deja.com
> http://www.deja.com/
Received on Thu Jan 04 2001 - 14:00:17 CST