Re: help!!!

From: <shiling_at_math.wayne.edu>
Date: 1999/06/02
Message-ID: <7j3dph$k91$1@nnrp1.deja.com>#1/1

You can to_char converting function + variety oracle datetime formats. Internally, all date type columns store both date and time.

SQL> select * from myt
  2 where to_char(oracle_date,'hh:mi:ss') = '10:25:36'   3 ;

ORACLE_DA

---

07-SEP-99 SQL> select to_char(oracle_date,'mm-dd-yy hh:mi:ss') from myt;

TO_CHAR(ORACLE_DA

---

09-07-99 10:25:36

In article <375454FA.35184106_at_cs.auc.dk>,   Chen Li <erpeng_at_cs.auc.dk> wrote:
> Hi, all
>
> I want to select a record which has the latest date. But the date
> consists of two field: date
> (YYYY:MM:DD) and time(HH24:MI:SS). How to do that? Thanks in advance.
>
> Simon
>
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Wed Jun 02 1999 - 00:00:00 CDT