Path: news.easynews.com!newsfeed1.easynews.com!easynews.com!easynews!news.alt.net!news.usenetgateway.com!not-for-mail
From: cbou <member27611@dbforums.com>
Newsgroups: comp.databases.oracle.tools
Subject: Re: forms6/date
Date: Fri, 04 Apr 2003 08:06:38 +0000
Organization: dBforums
Lines: 7
Sender: cbou
Message-ID: <2728507.1049443598@dbforums.com>
References: <b6j8ng$72h$1@serv1.iunet.it>
User-Agent: dBforums
X-Original-NNTP-Posting-Host: dbforums.com
X-Original-Trace: 4 Apr 2003 03:18:13 -0500, dbforums.com
X-Authenticated-User: paul
Xref: newsfeed1.easynews.com comp.databases.oracle.tools:58077
X-Received-Date: Fri, 04 Apr 2003 01:17:58 MST (news.easynews.com)


you must need the TO_CHAR function.
For only date TO_CHAR (:ITEM, 'DD/MM/YYYY')
For only hour TO_CHAR (:ITEM, 'HH24:MI:SS')

--
Posted via http://dbforums.com