Path: news.f.de.plusline.net!news-fra1.dfn.de!newsfeed.hanau.net!newsfeed01.sul.t-online.de!t-online.de!news.csl-gmbh.net!feeder.news-service.com!138.199.65.86.MISMATCH!sn-xt-ams-06!sn-xt-ams-11!sn-xt-ams-04!sn-post-ams-01!sn-post-sjc-01!supernews.com!corp.supernews.com!not-for-mail
From: "klabu" <klabu@mailinator.com>
Newsgroups: comp.databases.oracle.server
Subject: trunc sysdate
Date: Wed, 6 Jun 2007 17:04:59 -0400
Organization: Posted via Supernews, http://www.supernews.com
Message-ID: <136e8chssud595b@corp.supernews.com>
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3028
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028
X-Complaints-To: abuse@supernews.com
Lines: 10
Xref: news.f.de.plusline.net comp.databases.oracle.server:199055

10gR2/Solaris 8

how to trunc seconds off sysdate ?

so it returns like this : "06-06-2007 05:12:00" instead of  "06-06-2007 
05:12:18"

thanks