Re: sysdate without time

From: Andy Hassall <andy_at_andyh.co.uk>
Date: Thu, 27 Jul 2006 22:40:52 +0100
Message-ID: <hmcic21posbi1jo3to1hl2v5bns3ihg4he@4ax.com>

On Thu, 27 Jul 2006 17:21:33 -0400, Bertie Brink <bhb_at_donotspammailme.com> wrote:

>What is the best way to assign sysdate to a column in a trigger with
>time component set 00:00:00?
>
>Also how can one compare a column to sysdate in a query, while ignoring
>the time components in both?

TRUNC

-- 
Andy Hassall :: andy@andyh.co.uk :: http://www.andyh.co.uk
http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool

Received on Thu Jul 27 2006 - 16:40:52 CDT