sysdate without time

From: Bertie Brink <bhb@xxxxxxxxxxxxxxxxxxx>
Date: Thu, 27 Jul 2006 17:21:33 -0400

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?

Thanks

Bertie Brink
Life is a sexually transmitted disease. R. D. Laing
http://www.setdefault.com/ : http://www.csmonitor.com/
.

Follow-Ups:
- Re: sysdate without time
  - From: Andy Hassall

Prev by Date: Re: Insufficient privileges error when connecting via /nolog?
Next by Date: Oracle 9.2.0.6 Memory leak
Previous by thread: advanced queue latency
Next by thread: Re: sysdate without time
Index(es):
- Date
- Thread

Relevant Pages

Re: trunc sysdate
... You can't selectively 'truncate' bits and pieces of the time component ... from SYSDATE using trunc(); it's all or nothing. ...
(comp.databases.oracle.server)
Re: sysdate without time
... Andy Hassall wrote: ... time component set 00:00:00? ... Since the data is stored in the table with the time portion set to ...
(comp.databases.oracle.server)
Re: DateTime.Compare question
... On May 28, 2:58 pm, SandpointGuy ... I need to compare 2 dates, using the second format, and I ... DateTme.Now include a time component. ...
(microsoft.public.dotnet.languages.csharp)
Re: datetim convertion to date
... to have datetime, you will also have time component. ... if you want to compare only the date component, ... GetDate(), 110). ...
(microsoft.public.sqlserver.programming)