select trunc(date_Field) from dual
will return just the date part..
but they're using SQL server,
I dont think trunc works with that :)
perhaps
select convert(datetime, convert(varchar(10), DateField, 101), 101)
http://msdn.microsoft.com/library/default.asp?url="">
On Tue, 24 Aug 2004 14:58:43 -0700, Casey C Cook <[EMAIL PROTECTED]> wrote:
> trunc ?
>
> Thanks,
> CC
> x56927
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]