Re: Date Functions

From: DA Morgan <damorgan_at_exesolutions.com>
Date: Mon, 17 Feb 2003 15:28:09 -0800
Message-ID: <3E517009.E13DD1BB@exesolutions.com>

Lee Fesperman wrote:

> Robert Klemme wrote:
> >
> > "Lee Fesperman" <firstsql_at_ix.netcom.com> schrieb im Newsbeitrag
> > news:3E509498.475D_at_ix.netcom.com..
> > > --B wrote:
> > > >
> > > > Hi,
> > > >
> > > > I have a date column having value like '1/1/1900 2:30:00 PM'.
> > > > Is there an easy way to get time in 24hr scale using some functions,
> > for
> > > > above example it should return '14:30'?
> > >
> > > For Java 'methods', check java.text.SimpleDateFormat.
> >
> > That's for printing. To directly access the value use a Calendar.

>

> ??? And what method in Calendar will return '14:30'?

>

> --
> Lee Fesperman, FirstSQL, Inc. (http://www.firstsql.com)
> ==============================================================
> * The Ultimate DBMS is here!
> * FirstSQL/J Object/Relational DBMS (http://www.firstsql.com)

 select to_char(sysdate, 'HH24:MI:SS') from dual

Daniel Morgan Received on Mon Feb 17 2003 - 17:28:09 CST