How to select latest date

[leonard905]

Hi,

How can I get to_date function to return the hours and minutes like to_char: HH24:MI. I'm only getting the date.

Thanks,
leo

[Mr.Hanky]

SELECT TO_CHAR
(SYSDATE, 'MM-DD-YYYY HH24:MI:SS')"NOW"
FROM DUAL;

http://download-west.oracle.com/docs...129a.htm#84850

[leonard905]

It's not easy when you have a date like:

31-OCT-2004 10:00 and 01-NOV-2004 13:00 and you want to get the latest date. ie. 01-NOV-2004 13:00.

How do you do this. My query below brings back only the date and not the timestamp.


select to_char(max(to_date(mod_date,'DD-MON-RR')), 'MON-DD-YYYY HH24:MI') from table1

[marist89]

ah, the real question.

of course, you're truncating the date.

[leonard905]

Okay. So how should I do it. Any help is appreciated.

[marist89]

1. Why do you have to convert to_date anyway?
2. example structure, data, please

[leonard905]

Thanks. I got it to work by adding a subquery:

select to_char(mod_date, 'MON-DD-YYYY HH24:MI') NewDate from Table1
where mod_date = (select max(mod_date) from Table1);

[jmodic]

Oh boy, what an SQL!

select to_char(MAX(mod_date), 'MON-DD-YYYY HH24:MI') NewDate from Table1;