Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> trunc sysdate

trunc sysdate

From: klabu <klabu_at_mailinator.com>
Date: Wed, 6 Jun 2007 17:04:59 -0400
Message-ID: <136e8chssud595b@corp.supernews.com>


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 Received on Wed Jun 06 2007 - 16:04:59 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US